Stable Date

Solved/Closed
Sam - 25 Nov 2009 à 05:22
aquarelle Posts 7185 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 - 25 Nov 2009 à 13:40
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 7185 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 491
25 Nov 2009 à 13:40
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