How can I stop/remain from changing the value in the Lapse days [Closed]

Report
Posts
4
Registration date
Thursday December 14, 2017
Status
Member
Last seen
December 17, 2017
-
Posts
4
Registration date
Thursday December 14, 2017
Status
Member
Last seen
December 17, 2017
-
Hello,

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.

3 replies

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Davion1122, Good morning.

Suppose:
Date Completed column is G

Try to use:

=IF(G12=0, IF(OR(ISBLANK(TODAY()),ISBLANK(F12)),"",TODAY()-F12) ,"")

Please, tell us if it worked as desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4
Registration date
Thursday December 14, 2017
Status
Member
Last seen
December 17, 2017

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.

Help me please.
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Davion1122, Good morning.

Excel works dynamically.
He makes the action of the moment happen.

For the formula to count the days and depending on the situation stop counting and remain the value in the cell, Excel VBA programming is required.

That's what I think.
I don't know VBA.

Maybe some other colleague can do that with formulas.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4
Registration date
Thursday December 14, 2017
Status
Member
Last seen
December 17, 2017

Thank you Sir,
Your effort is much appreciated
Posts
4
Registration date
Thursday December 14, 2017
Status
Member
Last seen
December 17, 2017

All IT professionals out there please help me.