Stable Date

Solved/Closed
Sam - Nov 25, 2009 at 05:22 AM
aquarelle
Posts
7115
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 2, 2022
- Nov 25, 2009 at 01:40 PM
Hello,
Is there any function in Microsoft Excel where in we can get a stable date, the date should not change as it changes depending on the system in TODAY() and NOW(). once it takes the system date it should not change for the next day......

Thanks
Samran Pasha

1 reply

aquarelle
Posts
7115
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 2, 2022
491
Nov 25, 2009 at 01:40 PM
Hello,
I don't think so but you can use a keys combination. Select the cell where you want to insert the current date: just press the Ctrl key and the ; key at the same time.
Best regards
0