How can I stop/remain from changing the value in the Lapse days [Closed]
Report
Davion1122
Davion1122
- Posts
- 4
- Registration date
- Thursday December 14, 2017
- Status
- Member
- Last seen
- December 17, 2017
Davion1122
- Posts
- 4
- Registration date
- Thursday December 14, 2017
- Status
- Member
- Last seen
- December 17, 2017
Related:
- How can I stop/remain from changing the value in the Lapse days
- To finish securing your account, please verify your identity and change your password. your account will remain hidden until you - How-To - Facebook
- Change hotmail password - How-To - Hotmail
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- How to change primary email on facebook - How-To - Facebook
- How to change number of bestfriends on snapchat with new update 2019 - How-To - Instant Messaging
3 replies
Mazzaropi
- Posts
- 1887
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- February 27, 2021
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
- 1887
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- February 27, 2021
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
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Get More Followers on Instagram
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- How to Install a VPN
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.