|Subject:||Summing monthly data from weekly data input, with a twist|
|Date:||Mon, 28 Jul 2008|
I'm hoping an Excel wizard can help me... I know enough about Excel to be
dangerous, but this issue is giving me a migraine.
I have weekly data organized by row with the first cell of the row
indicating the week (i.e. Jan 3, 2008). Subsequent week dates are 7 days
apart through the remainder of the year.
The trick is...I want to be able to sum a month's data and display it in a
"Current Month" column, based on the current date, so that only the current
month's data displays. For example, in July 2008, only the sum of available
data for July will display. Once August 1st arrives, then August's data
displays in the "Current Month" column.
Any help would be greatly appreciated!