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 exam...
For days engaged try-
=MIN([@[End Date]],TODAY())-[@[Start Date]]Or
=IF([@[End Date]]="",TODAY(),[@[End Date]])-[@[Start Date]]