Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Weekly data allocated to months
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. |
#2
|
|||
|
|||
Hi
a question up front: How are your weeknumbers defined (ISO definition, Excel definition, etc.) -- Regards Frank Kabel Frankfurt, Germany "Henry Bolton" schrieb im Newsbeitrag ... 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. |
#3
|
|||
|
|||
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. "Frank Kabel" wrote: Hi a question up front: How are your weeknumbers defined (ISO definition, Excel definition, etc.) -- Regards Frank Kabel Frankfurt, Germany "Henry Bolton" schrieb im Newsbeitrag ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) | |||
Weekly data into Calendar Weeks | Excel Worksheet Functions |