d4vem
07-26-2006, 11:19 AM
Hi All,
I have a 2 sheets. The first sheet details values/amounts on a weekly to weekly basis ending on a Saturday. Each column contains the end of the week. Each row contains the amount for each week over a duration of 2 years (Yes thats 104weeks!!!! and columns). What I need to do is calculate the month of the last Saturday in each week (not bothered if the week crosses a month) and convert each week to a month on an 2 year basis in a seperate sheet by month.
If thats confusing then the example is
Sheet1
Column A through to AZ (weekly - 104weeks = 2 years)
Sheet2
Column A through to X (monthly - 1st month to 24th month)
The problem I am having is incorporating the year into the date for the look up
Thanks in advance for any assistance:beerchug:
I have a 2 sheets. The first sheet details values/amounts on a weekly to weekly basis ending on a Saturday. Each column contains the end of the week. Each row contains the amount for each week over a duration of 2 years (Yes thats 104weeks!!!! and columns). What I need to do is calculate the month of the last Saturday in each week (not bothered if the week crosses a month) and convert each week to a month on an 2 year basis in a seperate sheet by month.
If thats confusing then the example is
Sheet1
Column A through to AZ (weekly - 104weeks = 2 years)
Sheet2
Column A through to X (monthly - 1st month to 24th month)
The problem I am having is incorporating the year into the date for the look up
Thanks in advance for any assistance:beerchug: