I am trying to create a spreadsheet to track weekly, monthly, & YTD project costs. The spreadsheet is a list of projects in column A and the budget available per project in column B. The next 52 columns are setup with dates along the heading ie. 3rd January, 10th January, 17th January and so on to the end of the year. Data is entered weekly.
I am looking to work out two totals on is current spend to date which I can do using the sum function.
The second total is for the Current Month ie. sum for January. Then when it becomes Febuary the column resets and starts again untilit is March.
Any help would be appreciated.
I am currently using 2003, but moving to 2010 shortly
Thanks
Salar
I am looking to work out two totals on is current spend to date which I can do using the sum function.
The second total is for the Current Month ie. sum for January. Then when it becomes Febuary the column resets and starts again untilit is March.
Any help would be appreciated.
I am currently using 2003, but moving to 2010 shortly
Thanks
Salar