Forum Discussion
Solved
Need help w/formula to stop counting age of item when status changes to "Close"
Need help w/formula to stop counting age of item when status changes to "Close". Below is the current formula I'm using which continues to count age even when item is no longer active =TODAY()-J...
The formula should be:
=IF(E2="Closed", L2-H2, TODAY()-H2)
notice the last cell reference should be H2 not L2
alternatively you could use:
=IF(E2="Closed", L2, TODAY() ) - H2
because you want to subtract the Reported On date from EITHER the Closed Date (L2) OR Today's date
How about this?
=IF(K10="Close", "", TODAY()-J10)