How to Add Current Date & Time in Google Sheets

Google Sheets

Google Sheets provide a wide range of functions to perform tasks. While you have to manually add date and time to the Google Spreadsheet, it could also be done using NOW and TODAY function. NOW and TODAY function shows current date and time on your Google Spreadsheet. With this function, you don’t have to manually add the date and time.

Also, learn How to Hide Rows and Columns in Google Sheets

NOW and TODAY functions normally updates date and time regularly but you can also make it non-updatable by using some Keyboard shortcuts.

Adding Current Date and Time using NOW

Here’s how you can do it:

  1. Launch the browser and open an already existing Google Spreadsheet or create a new one.
  2. Click on an empty cell in the Spreadsheet and Type “=Now()”Current Date and time using NOW function
  3. When inserted, the NOW function will stamp the current date and time in the cell according to the standard formatting.

By default, NOW function uses the time format according to your location but you can change that in Settings. To change the Default format go to File > Spreadsheet Settings.

Adding Date Using TODAY

With TODAY function you can add the current Date to your Google Spreadsheet. Unlike NOW function, TODAY function displays only the date not the time according to your locale (i.e. MM/DD/YY or DD/MM/YY). To use this function, follow the steps given below:

  1. Launch the browser and open an already existing Google Spreadsheet or create a new one.
  2. Just like NOW function, all you have to do is click on an empty cell in the spreadsheet and type “=TODAY()” and the current date will be inserted to the cell.Current Date using TODAY function

You can change the default settings for NOW and TODAY function with which the date and time won’t change every day that normally does change every day.

Related: How to Freeze Rows or Columns in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *