I am trying to create an issues log that includes the aging of issues that are in "open" or "in progress" status for the following periods of time:
0-30 days
31-60 days
61-90 days
91-120 days
over 120 days
The aging should be from the date the issue was opened to the current date (including weekends). Once the aging is calculated, i want to be able to count the number of issues that fall within each range.
This assumes your data is in cells A3:A200. I hope you find it helpful.
Please Login or Register to view this content.
Last edited by Ikaabod; 09-18-2008 at 05:56 PM. Reason: Changed: ">0" to ">=0" in first formula
Thank you very much for the assistance. This was very helpful for the aging calculation. How would I filter this to only include items that are in an "open" or "in progress" status? The status is captured in Column I
Add this condition, --(($I$3:$I$200="OPEN")+($I$3:$I$200="IN PROCESS")), to each of those Sumproduct() formulas...
e.g.Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I'm not sure if I am doing something incorrectly. It is returning a #NA error. I am attaching the spreadsheet so you can see what i am trying to do.
Thank you so much for your help!
Your F column ranges must be same size as the B column range...
Also, the condition is "IN PROGRESS" not "IN PROCESS" as I had misinterpreted...
try:
Please Login or Register to view this content.
It worked perfectly! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks