Forum Discussion
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()-J10
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
You need to know the date it was closed. The easiest is to convert the "Closed" column to "Date Closed" and then:
=IF( ISNUMBER([DateClosed]), [DateClosed], TODAY() ) - J10For some reason, this formula isn't working for me. See below/attached for some additional context. I'm trying to reflect # of days open and # of days closed in one column instead of two. The # of days Open column continues to track the item although it's closed. I would like # of Days Open column to reflect 23 which is number of actual days it took to close.
Formula used for # of days to close: =IF(E2="Closed", L2-H2, TODAY()-L2)
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)
