Forum Discussion
IncompetentExcel
Aug 19, 2021Copper Contributor
Creating Timestamp Formula, Returning 1/0/1900
Google has been telling me that creating a formula that will create a STATIC timestamp is impossible. I took this as a challenge. I came up with the following formula that indexes from a separate...
Riny_van_Eekelen
Aug 19, 2021Platinum Contributor
IncompetentExcel Perhaps you can use the technique used in the attached file. It uses NOW() to enter a date/time stamp. Format the outcome as Date or Time as you wish.