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
Davion1122 Posts 4 Registration date Thursday December 14, 2017 Status Member Last seen December 17, 2017 - Dec 17, 2017 at 08:08 PM
Related:
- How can I stop/remain from changing the value in the Lapse days
- How to calculate 90 days from date in excel - Guide
- Skype last seen days ago - Guide
- How to change the dino in the dino game - Guide
- Change the scrolling of the document to vertical - Guide
- How to change language in kmplayer - Guide
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
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 15, 2017 at 06:36 AM
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
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
Davion1122
Posts
4
Registration date
Thursday December 14, 2017
Status
Member
Last seen
December 17, 2017
Dec 17, 2017 at 07:59 PM
Dec 17, 2017 at 07:59 PM
Thank you Sir,
Your effort is much appreciated
Your effort is much appreciated
Davion1122
Posts
4
Registration date
Thursday December 14, 2017
Status
Member
Last seen
December 17, 2017
Dec 17, 2017 at 08:08 PM
Dec 17, 2017 at 08:08 PM
All IT professionals out there please help me.
Dec 15, 2017 at 03:32 AM
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.