While Microsoft Excel automatically ... To manually enter a static date in Google Sheets, insert the date into the function, using the year, month and day, such as, "=DATE(2021,01,28)." ...

you can use a keyboard shortcut to insert the current date into your Excel spreadsheets. Note that the shortcut does not use the TODAY function, so the date will not change the next time you edit ...

In this post, we will show you how to insert ... date/time formats in the above formula to display the timestamp in your preferred style. Press Alt + Q to close the VBA editor and return to Excel.