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