I looked at a few formulas on here but its not working the way I need it to. Right now I am using
=IF(ISBLANK($H38),TODAY()-C38,$H38-C38)
which stops when a date is entered in column "h"
I just need it to stop count if there is a date entered in column "h" or if the status has changed ( Column d) to one of the ones listed below.
Column "c"= date submitted
Column "d" = Status ( need it to stop counting days when status has changed to "declined", "spotlight", "interview")
Column "i" = count of days located
Column " h" = day item submitted to next level
Column "o" = date of decline
Please Help !
=IF(ISBLANK($H38),TODAY()-C38,$H38-C38)
which stops when a date is entered in column "h"
I just need it to stop count if there is a date entered in column "h" or if the status has changed ( Column d) to one of the ones listed below.
Column "c"= date submitted
Column "d" = Status ( need it to stop counting days when status has changed to "declined", "spotlight", "interview")
Column "i" = count of days located
Column " h" = day item submitted to next level
Column "o" = date of decline
Please Help !