3 Ways to Add Dates Automatically in Google Sheets

Supreeth is passionate about technology and dedicates himself to helping people figure it out. An engineer by education, his understanding of the inner workings of all types of gadgets and devices ensures he provides top-notch guidance, tips, and recommendations to his readers. When away from the desk, you will find him traveling, playing FIFA, or hunting for a good movie.

Method 1: Automatically Enter the Current Date

Let’s start by automatically entering today’s date using theGoogle Sheetsdate function called TODAY(). This returns today’s date in a cell. Here’s how to use it.

Step 1:Open Google Sheets, place your cursor in a cell, and type the belowfunction.

Now, hit theenterkey.

There you go. You can now see today’s date in a cell on Google Sheets.

Alternatively, you can also use the key combinationCtrl +;on a cell in Google Sheets, it will return the current date.

Also Read:How to fix formulas not working in Google Sheets.

Method 2: How to Autofill Dates

Autofill is a feature on Google Sheets that helps you fill the cells in series with data based on values present in a few cells. For example, if I enter a date in Cell A1, I can fill the entire column A with dates, since Google Sheets recognizes that there’s a date in A1 and when prompted to autofill the rest of the column, it fills it with increasing order of dates.

However in case, you want to check the date and time format before you enter a date, here’s how to do it.

We can autofill days, weeks, and months in Google Sheets. Let’s see how we can do that.

1. Autofill Days in a Column in Google Sheets

Step 1:Open Google Sheets andenter a datein a cell.

Step 2: Click and hold on the bottom right cornerof the cell anddrag it downto the cell you want to autofill dates for.

As you can see, the dates are auto-filled for all the selected cells in a column in the same format.

2. Autofill Weeks in a Column on Google Sheets

Here’s how you can autofill dates in a column in Google Sheets that are a week apart.

Step 1:Open a Google Sheet andenter two dates that are a week apartin the consecutive cells.

Step 2: Select and highlightthe cells.

Step 3:Click on thebottom right cornerof the highlighted cells, anddragit until the cell you want to autofill.

As you can see, the column is filled with dates that are a week apart.

3. Autofill Months in a Column on Google Sheets

Step 1:Open Google Sheets andenter two dates a monthapart in consecutive cells in the column.

Step 2: Select and highlightthe cells.

Step 3:Click on thebottom right cornerof the highlighted cells, and drag it until the cell you want to autofill.

The column is auto-filled with dates that are a few months apart.

Method 3: Autofill Weekdays Only

If you are using Google Sheets at work, you seldom need to enter data for a non-working day or a weekend. But in the previous method to autofill dates, weekends were also auto-filled. If you are working on a data-heavy spreadsheet, it is time-consuming to manually delete weekends.

Therefore, you can autofill dates excluding the weekends – Saturdays and Sundays. Here’s how.

Step 1:Open Google Sheets andenter a datein a cell that you want to start with.

Step 2:Enter theformulain the cell below. Make sure you enter the correct column in the formula. (column A in our case)

Step 3:The next cell is automatically filled with the next working day.

Step 4:Click on thebottom right cornerof the cell, anddrag itdown to the cell that you want to fill. The formula governs the pattern, and will only enter working days and exclude Saturdays and Sundays.

As you can see in the image below, the cells contain only working days, and Saturdays and Sundays are excluded.

Next, let us see how we can merge date and time on Google Sheets. This will be helpful if you have two columns: one for the date and another for the time.

Bonus: Merge Date and Timestamp on Google Sheets

When you have a column with a date and a time that corresponds to it in a column, it makes sense to merge them into a single column and minimize the redundancy. Here’s how to do it.

Step 1:Open Google Sheets and enter the below formula that helps you merge date and time functions on Google Sheets into a text.

Make sure you enter the right cell locations for the date and time respectively. In our case, it is A2 and B2.

Step 2:As you can see, the date and time are merged into a single cell as plain text. You can select and drag the merged cells to autofill the entire column if you have multiple separate date and time cells.

Also Read:How to clear the cell content in Google Sheets.

Was this helpful?

Last updated on 28 July, 2024

Leave a ReplyCancel reply

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

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

3 Ways to Fix Friend Request Not Working in Discord

4 Ways to Fix Instagram Story Not Uploading on iPhone and Android

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.