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.
It’s not difficult. Approx so here FirstWeeksOfYear.ods
Just use DATE(), WEEKDAY(), WEEKNUM() and TEXT()
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.)
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
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.