MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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.