Weekly data allocated to months

G

Guest

Hi
If anyone can help me solve this I would be very grateful.

I have weekly data for a year, ie 52 data points, one for week 1 one for
week 2 etc.

I need to convert this data into monthly data.

So I am hopeing that Excel can somehow allocate each week to the correct
month and for weeks that span 2 months, to pro rata it over the two.

For example week 5 will fall in to Jan and Feb and if the 1st Feb falls on
the Tuesday then I want it to allocate Sun and Mon to Jan and Tue, Wed, Thur,
Fri, Sat to Feb.

Thanks in advance for any help in how to do this.
 
F

Frank Kabel

Hi
a question up front: How are your weeknumbers defined (ISO definition,
Excel definition, etc.)
 
G

Guest

Sorry not sure what ISO and Excel defs are, but i have defined them as week 1
is the first week of the year, week 2 is the second etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top