Add Current Date in a Cell in Google Sheets

In Google Sheets, two quick ways exist to add the current date in a cell.

  • TODAY Function
  • Keyboard Shortcut

And in this tutorial, we will learn both methods.

TODAY Function to Get the Current Date

TODAY is a specific function that returns the current date as per the date you have in your system.

add-current-date

To use it today, you need to enter it in a cell. This function doesn’t argue to define; you must enter the function, starting and closing parentheses. And then, hit enter to get the date.

Today is a volatile function that updates its values every time you update anything in your worksheet. It also makes it dynamic because when the date changes in your system or the date changes, it changes its result value.

Keyboard Shortcut to Enter Current Date

And there’s a keyboard shortcut that you can use to enter the current date instantly. The keyboard shortcut is:

Ctrl + ;

Select the cell where you want to enter the date, press and hold the Ctrl and press the (;) key.

shortcut-to-enter-current-date

This keyboard shortcut also adds the current date, which is the date in your system, by using the default date format.

Get the Sample Sheet