N
Nicole
I have a spread sheet and on it I have a date range that is different per row.
So row 1 may be Sept 09 to May 10, row two may may June 09 to July 10.
I also have a value of hours that I want to allocate to each of these
periods of time ie. row 1 may be 3 hours per week, row 2 could be 5 hours
per week and so on...
Is there any way that I can get excel to automatically format the cells
across the date range so that I can total up per period how many hours are
allocated? And it needs to look something like this...Currently I have to
manually input each line.
June July Aug Sept Nov Dec Jan Feb Mar Apr May Jun July
3 3 3 3 3 3 3 3
5 5 5 5 5 5 5 5 5 5 5 5 5
Thanks!
So row 1 may be Sept 09 to May 10, row two may may June 09 to July 10.
I also have a value of hours that I want to allocate to each of these
periods of time ie. row 1 may be 3 hours per week, row 2 could be 5 hours
per week and so on...
Is there any way that I can get excel to automatically format the cells
across the date range so that I can total up per period how many hours are
allocated? And it needs to look something like this...Currently I have to
manually input each line.
June July Aug Sept Nov Dec Jan Feb Mar Apr May Jun July
3 3 3 3 3 3 3 3
5 5 5 5 5 5 5 5 5 5 5 5 5
Thanks!