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

Closed
Davion1122 Posts 4 Registration date Thursday December 14, 2017 Status Member Last seen December 17, 2017 - Updated on Dec 14, 2017 at 04:45 AM
Davion1122 Posts 4 Registration date Thursday December 14, 2017 Status Member Last seen December 17, 2017 - Dec 17, 2017 at 08:08 PM
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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Dec 14, 2017 at 09:28 AM
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
Davion1122 Posts 4 Registration date Thursday December 14, 2017 Status Member Last seen December 17, 2017
Dec 15, 2017 at 03:32 AM
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.
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Dec 15, 2017 at 06:36 AM
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
Davion1122 Posts 4 Registration date Thursday December 14, 2017 Status Member Last seen December 17, 2017
Dec 17, 2017 at 07:59 PM
Thank you Sir,
Your effort is much appreciated
0
Davion1122 Posts 4 Registration date Thursday December 14, 2017 Status Member Last seen December 17, 2017
Dec 17, 2017 at 08:08 PM
All IT professionals out there please help me.
0