Hi All,
I've got a table showing planned % targets that a project needs to achieve, broken down by month. I've identified how many reporting periods there are in each month (i.e. number of Friday's) and what I should be achieving per week (monthly planned % divided by number of Friday's).
My problem lies in writing a formula that determines what my overall planned % should be based on today's date.
The formula needs to:
1. Determine which reporting period TODAY() falls into (i.e. 22-JAN-13 = 4th peiod for January 2013)
2. Multiply the Weekly Planned % - Increment (cell B16) by the number derived in first step, then added the previous months Cumulative Planned (row 9) to this number
Any assistance would be greatly appreciated.
Reporting Period.xlsx
Bookmarks