Dear All,

This is my first post to the forum, so I hope I have followed all the rules.

I hope it is possible that you could help me with the following problem. This has been bugging me for some time now.

I have a table that lists days spent on an activity by month (D7:D17). The next column keeps a running total of these days (E7:E17). From the cumulative totals (E7:E17) I need to split the days into categories of 0 to 45 days, 46 to 60 days and finally 61+ days.

I have managed to use formulae to calculate the 0 to 45 days (F7:F17) and 60+ days (N7:H17), based on the cumulative column, but I'm having trouble with the 46 to 60 days formula (G7:G17). I'm hoping a formula can be created that looks at the cumulative days already spent and if the cumulative days up to that month are over 45 days but less than 60, it will add in the days within that range for the month in question.

I know that the results in the following cells should be:
G7:G9 = all 0
G10 = 2
G11 = 0
G12 = 13
G13:G17 = all 0
Total (cell G18)= 15 days

At the top of the table there are some input boxes (E2:H4). I'd hope that the formula can reference these cells so if the need to change the ranges occurs, I can simply change these cells.

I have enclosed the Excel file with the table.

Any help that can be offered would be most appreciated.

Regards,

David

Cumulative day ranges.xlsx