Hi,

I have data I’m capturing per week but want to report by month.

I believe there is a table that says something like Jan equals weeks 1 to 5, February equals weeks 6 to 10 etc. etc. Don’t Accountants or similar use this type of week to month conversion?

I’ve tried Googling but obviously not asking the right question …. Anyone know where I can find out this info for 2010 and 2011?

Sorry for the boring question!

Thanks,

in 2011:-

jan 1-4
feb 5-8
mar 9-13
apr 14-17
may 18-21
jun 22-26
jul 27-30
aug 31-35
sep 36-39
oct 40-43
nov 44-47
dec 48-52

Taken from our production calendar.

you do have to watch for the occasional 53 week year.

2010 is the same until

aug 31-34
sep 35-39
oct 40-43
nov 44-47
dec 48-52

Superb CP!

Really much appreciated!

Happy Christmas.