How to Insert Current Date and Time in Google Sheets (Easy)

Written by Abid Akon

Here's what we'll cover:

As usual, Google sheets provides a wide range of actions and benefits, which includes inserting the current date and time in your worksheet. Instead of inputting the time and date manually on your worksheet.

Google sheets have inbuilt functions and formulas that perform such tasks and update the time and date daily. 

In this tutorial, we are going to discuss the three methods used to insert time and dates in Google sheets.

Adding the Current Date and time using the NOW function.

The NOW function is a volatile and dynamic function. It is easy to operate and requires no additional parameters in its formula syntax. This function inserts both the date and time. The default format of the inserted date is DD/MM/YY which is the standard format.

The NOW formula takes the syntax below.

=NOW()

As stated earlier, there are no required parameters. If values or cell references are inputted in the formula, it would result in an error.

Step 1: In an empty cell, type in the formula =NOW()

1 How to Insert Current Date and Time in Google Sheets

Step 2: Press Enter on the keyboard. The present date and time are inserted into the worksheet.

2 How to Insert Current Date and Time in Google Sheets

Also, due to time zones globally, you can change the format of the inserted data.

Step 1: Select File on the toolbar.

3 How to Insert Current Date and Time in Google Sheets

Step 2: Select Settings.

4 How to Insert Current Date and Time in Google Sheets

Step 3: Click on the Calculation tab. Select the Recalculation from the drop-down menu displayed.

5 How to Insert Current Date and Time in Google Sheets
6 How to Insert Current Date and Time in Google Sheets

You can also select locale and time zones under the General tab.

7 How to Insert Current Date and Time in Google Sheets

This method is as easy as pie and it dynamically recalculates as time passes by, when any change or refresh is made on the worksheet.

8 How to Insert Current Date and Time in Google Sheets

Check out How To Add A Date Picker In Google Sheets.

Finding The Date and time Using the TODAY function.

This function is similar to the NOW function in terms of its versatility and dynamic nature but it only inserts the current date. The function takes the following syntax.

=TODAY()

The parentheses are required blank, if filled could result in an error.

This function also recalculates automatically as days pass by. Past days can be inserted by adding and subtracting the number of days and if it’s by a year past or a year further, you add or subtract by 365 days.

Step 1: In an empty cell, type in the formula =TODAY()

9 How to Insert Current Date and Time in Google Sheets

Step 2: Press Enter on the keyboard. The present date is inserted into the worksheet.

10 How to Insert Current Date and Time in Google Sheets

As said earlier, the default format is automatically placed on the inserted time, but it can be changed using the Format tool. This method also applies to the NOW function.

Step 1: Select the cell or range of cells containing the inserted time and date.

Step 2: Select Format on the toolbar.

11 How to Insert Current Date and Time in Google Sheets

Step 3: From the drop-down menu, select Number.

12 How to Insert Current Date and Time in Google Sheets

Step 4: Another list is displayed, select Date. To display the present time only, you’d select Time rather.

13 How to Insert Current Date and Time in Google Sheets

Also, you can customize the Date and Time format.

Step 1: Select the cell or range of cells containing the inserted time and date.

14 How to Insert Current Date and Time in Google Sheets

Step 2: Select Format on the toolbar.

Step 3: From the drop-down menu, select Number.

15 How to Insert Current Date and Time in Google Sheets

Step 4: Select Custom Date and Time. Additional formatting alternatives are also found here.

16 How to Insert Current Date and Time in Google Sheets

Now, you can format the text, date, time, numbers, and characters like the slash etcetera. You can select and apply a format.

17 How to Insert Current Date and Time in Google Sheets
18 How to Insert Current Date and Time in Google Sheets

With the applied format, the TODAY and NOW functions are used to insert the current date and time in your worksheet.

Insert Static Dates into Google Sheets.

Suppose you don’t want the dates and times on the worksheet to change constantly, you can use the method to insert a static date and time into your Google Sheet. This technique is quite easy to understand and quick to use. It is done by using a keyboard function.

  • To insert a static date in a cell, you use the keyboard shortcut, Ctrl key + ; (semicolon)
  •  To insert a static time into a cell, you use the keyboard shortcut, Ctrl key + Shift + : (colon)

Note that the dates and times are static and do not change as other modifications are made on the worksheet.

Final Thoughts.

Above, we covered this topic fully and successfully. The insert dates are very important especially when you are keeping track of specific items or keeping a sales record in your Google Sheet. 

I hope you found this article informative and useful. Thanks for reading.

Abid Akon

Abid Akon

I am a tech content writer. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I am writing articles to share my tech knowledge with you.

Related Articles

MD Abid Akon

Abid Akon

Hi, I am Abid. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I’ve created this website to share my technology keeping knowledge with you. Welcome to ”abidakon.com”

Abid Akon

My Personal Favorites
YouTube Channel