How to insert current date in Google Sheets

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.

Insert current date using now and 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.