Forum Discussion
How to freeze a Days Count
I need help to know if this is possible. I want to count the number of days passed when someone is engaged. But I want that number to freeze when the end date is added.
The picture is an example of what I mean. When I enter in the formula =TODAY()-[@[Start Date]] It works at counting the days. But in line one you can see that it keeps counting even though the end date has been added. I would like it to look like line 9 where it stops the count on the end date.
Is there a formula for that?
3 Replies
=IF(ISBLANK(C2), TODAY() - A2, C2 - A2)
If End Date is blank, it counts, otherwise, it stops
For days engaged try-
=MIN([@[End Date]],TODAY())-[@[Start Date]]Or
=IF([@[End Date]]="",TODAY(),[@[End Date]])-[@[Start Date]]Like this:
=IF([@[End Date]]="", TODAY(), [@[End Date]])-[@[Start Date]]
