How to create an Aging Report for multiple status changes

[RJL3313]

Hello,

I am trying to create an aging report with for a process that has several status changes. I need to see how long it took to go from one status to another. For 0-7 Days, 8-14 Days, 15-21 Days, >21

I have attached a sample spreadsheet of my data. I can be changed to accommodate the information.

Thanks,
RJL3313

[Pauleyb]

This is what I put in D12. Not sure where you wanted the data. You should be able to see how to modify the formula for your other date deltas.
=INDEX($A$7:$A$10,MIN(4,1+INT(DATEDIF(C7,D7,"d")/7)))

[RJL3313]

Thank You Pauley.

It isn't working though. I am getting a #NUM error. I put the formula in D12 as well.

Any thoughts?

[Pauleyb]

Yes, I forgot that I corrected your date. I assume you did not mean for D7 to be in 2012. Change it to 2015. C8 looks suspect, too.

[RJL3313]

It Worked!!!

Can't thank you enough!!

RJL3313

[RJL3313]

Hey Pauley, I have the 2nd question for you. I needed to count how many of each status has which category of days. i.e. Total how many times the cell includes >21 Days and Create, etc. Here is my formula: COUNTIFS(B13:F13,"Create",B14:B17,"Days") I am including an updated spreadsheet.

[Pauleyb]

RJL3313,
Glad it worked. Please open a separate thread with this new problem. I will say that you are using COUNTIF improperly, the ranges need to be the same size and 'shape'. And, since I'm unsure what you are expecting, this will prompt more dialog better captured in a different thread and title. In that thread, please include what you are expecting as a result, too.

Thanks,
Pauley