Automatic update.
Closed
ramil261
Posts
1
Registration date
Sunday February 19, 2017
Status
Member
Last seen
February 20, 2017
-
Feb 20, 2017 at 04:24 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 20, 2017 at 05:55 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 20, 2017 at 05:55 AM
Hello,
Please help me on this.
Is there a formula in which TODAY will not auto update. Let's say I want "2/20/2017" to stay as "2/20/2017" and the following day it wont change to "2/21/2017"?.. Because here is what Im trying to do. Once I put an entry to A2 cell, it will automatically put a date on B2 cell. However when I used today on b2 cell which is "2/20/2017" yesterday, it will change to "2/21/2017" which is today. What I want is for B2 cell to stay as "2/20/217" and not change to "2/21/2017" the following day. Is that possible?. Please help. Thank you very much..
Thank you in advance for your help.
Please help me on this.
Is there a formula in which TODAY will not auto update. Let's say I want "2/20/2017" to stay as "2/20/2017" and the following day it wont change to "2/21/2017"?.. Because here is what Im trying to do. Once I put an entry to A2 cell, it will automatically put a date on B2 cell. However when I used today on b2 cell which is "2/20/2017" yesterday, it will change to "2/21/2017" which is today. What I want is for B2 cell to stay as "2/20/217" and not change to "2/21/2017" the following day. Is that possible?. Please help. Thank you very much..
Thank you in advance for your help.
Related:
- Automatic update.
- Tentacle locker 2 pool update apk - Download - Adult games
- Ps3 update - Guide
- How to update facebook account - Guide
- Nvidia automatic driver detection tool - Guide
- Kunoichi trainer update - Download - Adult games
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Feb 20, 2017 at 05:55 AM
Feb 20, 2017 at 05:55 AM
Hello Ramil261,
A formula won't work in this case as the Today() function is volatile which means that it will always change. You can use the following shortcut key:-
Ctrl + ;
which will place a fixed date in a selected cell
or, the only other way is to use VBA, viz. a Worksheet_Change event. For example:-
I hope that this helps.
Cheerio,
vcoolio.
A formula won't work in this case as the Today() function is volatile which means that it will always change. You can use the following shortcut key:-
Ctrl + ;
which will place a fixed date in a selected cell
or, the only other way is to use VBA, viz. a Worksheet_Change event. For example:-
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Columns(1)) Is Nothing Then Target.Offset(, 1) = Date End If End Sub
I hope that this helps.
Cheerio,
vcoolio.
