Stable Date

Solved/Closed
Sam - Nov 25, 2009 at 05:22 AM
aquarelle Posts 7120 Registration date Saturday April 7, 2007 Status Anonymous Last seen April 14, 2023 - 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
Related:

1 reply

aquarelle Posts 7120 Registration date Saturday April 7, 2007 Status Anonymous Last seen April 14, 2023 490
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