There are a number of ways to insert current date in Google Sheets. This post is going to explore
- Inserting current date using functions
- Inserting current date using shortcut keys
Insert current date using Functions
You can insert current date using the NOW() or TODAY() function.
NOW() returns current Date and Time.
TODAY() returns only the Date.
One thing to note about using these functions is that these dates gets recalculated on change. You can change the settings from File -> Settings -> Calculation.
Insert current date using shortcut keys
- To insert date, use
Ctrl + ; - To insert date and time, use
Ctrl + Alt + Shift + ;
By using these short cut keys, the date and time will not be changed once you’ve entered it.