I have a problem in excel, how can I stop/remain from changing the value in the Lapse days Column as the days changing, if i will type value in the Date Completed column, the Lapse days must stop.
My formula in the Lapse days Column is this: =IF(OR(ISBLANK(TODAY()),ISBLANK(F12)),"",TODAY()-F12).
Any help will much appreciated.
Thanks.
Related:
How can I stop/remain from changing the value in the Lapse days
Hi Sir Mazzaropi,
It worked but the problem is this, the value in the Lapse days Column disappeared, I want only to stop the counting of lapses of days but the amount/value will remain there.
It worked but the problem is this, the value in the Lapse days Column disappeared, I want only to stop the counting of lapses of days but the amount/value will remain there.
Help me please.