Ask Your Question

Adding weekday range to corresponding week numbers

asked 2015-01-26 12:18:12 +0100

jantoko gravatar image

For 2015 the first 3 weeks of the year have these numbered day ranges

week 1 (29.12.)1.-4.1.

week 2 5.-11.1.

week 3 12.-18.1.

Can I produce this kind of list for the next 5 years for example somehow automatically so that I have the week number in one column and the range of numbered days in it on another? Working days, weekends, holidays don't have to be separated in any way.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2015-01-26 13:22:32 +0100

JohnSUN gravatar image

It's not difficult. Approx so here FirstWeeksOfYear.ods

Just use DATE(), WEEKDAY(), WEEKNUM() and TEXT()

edit flag offensive delete link more

answered 2015-01-26 14:04:28 +0100

Lupp gravatar image

updated 2015-01-26 14:08:10 +0100

If your demand is not restricted to the first three weeks you may also have a look into the attached example. It's using very simple formulae in most of the cells (as @JohnSUN did it for the second and the third week of any year) because it has only to count in steps of 7 days.ask45407ListingNumberedWeeks001.ods

Editing: (Sorry I had prepared my example before I saw the post by John. Didn't want to just throw it away.)

edit flag offensive delete link more


Why "throw it away"?!! It's nice solution... Why do you not use 3 as third parameter of WEEKDAY()? Then no need increment C11 by +1

JohnSUN gravatar imageJohnSUN ( 2015-01-26 14:34:36 +0100 )edit

answered 2015-01-26 21:08:17 +0100

jantoko gravatar image

Thank you for the answers. JohnSun was on the right track with his solution.

I tweaked and expanded it a little and now I have the whole list ready.

Thanks for the quick help.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-26 12:18:12 +0100

Seen: 169 times

Last updated: Jan 26 '15