Forum Discussion
Need help w/formula to stop counting age of item when status changes to "Close"
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
For 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