Forum Discussion
ImOKbutNot
Feb 04, 2025Copper Contributor
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...
Ahmed_Masoud97
Feb 04, 2025Iron Contributor
=IF(ISBLANK(C2), TODAY() - A2, C2 - A2)
If End Date is blank, it counts, otherwise, it stops