Week count to month
 

Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop

[Closed] Week count to month

4 Posts
3 Users
0 Reactions
47 Views
Posts: 0
Free Member
Topic starter
 

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,


 
Posted : 22/12/2010 3:26 pm
 cp
Posts: 8944
Full Member
 

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.


 
Posted : 22/12/2010 3:43 pm
Posts: 251
Full Member
 

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


 
Posted : 22/12/2010 3:44 pm
 cp
Posts: 8944
Full Member
 

2010 is the same until

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


 
Posted : 22/12/2010 3:45 pm
Posts: 0
Free Member
Topic starter
 

Superb CP!

Really much appreciated!

Happy Christmas.


 
Posted : 22/12/2010 3:48 pm