Week numbers

[beaintheuk]

Something always puzzled but it never occurred to me there might be a rule to this!!

How do you split the weeks that have two months it.  For instance this year week 27 has 3 working days in June and 2 in July, so which month will have week 27?

I have been given a spreadsheet where I have the months on a row and week numbers on the row below, I am supposed to put the week numbers in the relevant month...

How do I split week 36, 2 working days in August and 3 in September, etc...

Someone must have the answer somewhere!!! Simple I am sure.

Thanks
Bea

[gee4]

Why don't you put months across the top and weeks down the side that way you can split the number of days and you can see at a glance that week 27 had an overlap.

Will pm you my example.

G

[ecogirl]

I believe it goes to whichever month has the 4 days ( or 3 working days) so your week 27 would go to June.  This is unless you are doing a like-for-like comparison to last year and then you have got to copy what happened then, whether it was a four week or five week period. I think!

[beaintheuk]

Thanks Gee & CaroleAnne

Actually the spreadsheet reads like this:

June                                           | July    
wk23 wk24 wk25 wk26 wk27  | wk28 wk29 wk30.....

Difficult to reproduce here but I will put the week that has 3 or 4 days in one month under that month.

Thanks
Bea

[gee4]

Or just add another column so that June has week 24 with the days underneath and Jul also has week 24 with it's days underneath.

G

[gee4]

Bea,

Just noticed something on Outlook - a tick box to turn on week numbers!

So the week starting 28 June, is week showing as week 27.  That confirms my thinking that if 2 months start and end in the same week, surely the days belong to the week it falls in and in this case it is part of June?

Just a thought!

G