Task related Aging Report

[RJL3313]

I am having trouble creating an aging report for issue reporting. Basically I have a number of tasks that were created each month and I have to report on which month they were closed and obviously if they are still open.

Thank you,
RJL3313

[newdoverman]

It would help if your table did represent the data that you provided in order to know if the calculations are correct. Right now it is very confusing what you want as it appears that the value represents both Opened and Closed. For example C49 for January has a value but what does that value mean?

[Glenn Kennedy]

I had to make a few changes to the column and row headers, so that each month was entered as a date andformattedto look like a month name. This formula was used to calculate the number of closd cases, C49 cpied across and down:
=COUNTIFS($D$2:$D$43,">="&$B49,$D$2:$D$43,"<="&EOMONTH($B49,0),$E$2:$E$43,">="&C$48,$E$2:$E$43,"<="&EOMONTH(C$48,0))

and this formula, the open cases, copied down:
=COUNTIFS($D$2:$D$43,">="&$B49,$D$2:$D$43,"<="&EOMONTH($B49,0),$E$2:$E$43,"")

there is something odd in your data. i have highlighted 3 cases that were closed months before they were opened!!!