Stable Date

Solved/Closed
Sam - Nov 25, 2009 at 05:22 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - 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 response

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 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