Calculating an Aging Open Item
Hello, I am looking for a formula that would count the aging item that has any of the status (In Progress, Open, or Deferred).
If item has been "In Progress", "Open", or "Deferred" [Status], Count # of days from [Initiated Date] to TODAY.
If item has been Completed, it should not count the aging days and will return a value of zero since it is no longer an open aging record.
I've looked through the forums, but can't find something that appears similar. Thank you.
Help Article Resources
Check out the Formula Handbook template!