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 ✓ - Forum - Facebook
- Hotmail change 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
- 1837
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- October 17, 2020
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
- 1837
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- October 17, 2020
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
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.