How to Add Date in Google Sheets
How to Add Date Automatically in Google Sheets – Quick Steps
- Open Google Sheets
- Enter Date >> Select Cell
- Drag Down
- Release when Date entered
Google Sheets is a web-based spreadsheet offered by Google Docs Editor suite. Google Sheets provides you with many features such as real-time collaboration in projects with your friends, you can build a content calendar in Google Sheets. Putting a date on your Google Sheets is a good way to organize your work and it can be done in some simple and easy steps.
So, in this article, we will explore how we can put date automatically to a Google sheet.
How to Autofill Date in Google Sheets
Step 1: Open Google Sheets and Select a Document
Open your Google Sheets on your desktop and select a new spreadsheet or you can also select an existing one.
Step 2: Enter Date
After opening your Google sheet enter your desired date on a particular location and place your cursor on the corner of the cell in which the date has been entered.
Step 3: Select and Scroll down the Cell
Now in the cell in which you have entered the date select it and scroll down till your desired cell you want to enter the date.
How to Automatically Enter the Current Date on Google Sheets
1. Autofill Days in a Column in Google Sheets
Open your Google Sheet in which you want to autofill days and enter the day’s formula in a cell which is:
"=ARRAYFORMULA(SEQUENCE(10,1, TODAY(),1))"
Press Enter.
2. Autofill Weeks in a Column on Google Sheets
Open Google Sheets and enter the weeks formula:
"=ARRAYFORMULA(SEQUENCE(10, 1, DATE(YEAR(TODAY()), MONTH(TODAY()), 1) + (ROW(A1:A10)-1)*7))"
Press Enter to autofill the weeks in a column.
3. Autofill Months in a Column on Google Sheets
Enter the Month Formula:
"=ARRAYFORMULA(EOMONTH(DATE(YEAR(TODAY()), ROW(A1:A12), 1), 0))"
Press Enter.
How to Autofill Weekdays Only on Google Sheets
Step 1: Open Google Sheets and Select a Document
Open your Google Sheets on your desktop and select a new spreadsheet or you can also select an existing one.
Step 2: Enter WeekDays Formula
Enter the weekday formula and press Enter.
How to Enter Date Using Functions for Automatic Date Entry
Step 1: Open Google Sheets and Select a Document
Open your Google Sheets on your desktop and select a new spreadsheet or you can also select an existing one.
Step 2: Enter “=Today()”
After selecting a particular cell enter the formula: “=Today()” in the cell and press Enter.
Step 3: Date Entered Automatically
Now your date has been entered automatically in the cell.
How to Create a Date Formula in Google Sheets
1. Finding Specific Date
To find a specific date click on any of your cell and type the formula “=DATE(2023, 12, 25) // This will create the date December 25, 2023“.
2. Adding Subtracting Between Dates
Select any of you cells and enter the difference formula to find the difference between dates “=DATE(2023, 12, 25) + 7 // This will result in January 1, 2024 (7 days after December 25, 2023),
=DATE(2023, 12, 25) – 3 // This will result in December 22, 2023 (3 days before December 25, 2023)“.
How to Add Date Automatically in Google Sheets on Mobile Devices
Step 1: Open the Google Sheets App
To open Google Sheet App on your phone locate the icon and give it a click.
Step 2: Select your Google Sheet
After opening the Google Sheet app on your mobile click on the desired Google sheet in which you want to enter the date.
Step 3: Enter the Date, Select the Date and Click Copy
After opening your desired sheet enter a date in a particular cell and then select it to view some additional options from the options select Copy to copy the date first.
Step 4: Drag it Down and Click Paste
When you have selected the date drag it till you want to enter the date and then click on the Paste button to paste the copied date.
Step 5: Date Copied
When you will leave dragging the date it will stop copying and will be entered automatically in the cells and you don’t have to write the date one by one in the cells.
Shortcuts of Entering Date Automatically
- For Windows click “Ctrl + ;” button to enter the current date automatically.
- For Mac click “Command + ;” button to enter date in your google sheets.
- To enter current time in Windows press “Ctrl + Shift + ; “ to on your keyboard.
- To enter the current time in Mac press “Command + Shift + ; ” on your keyboard.
Conclusion
Entering the date automatically in Google Sheets is a good way, to save your time by writing the date manually and it can be done in some easy and simple steps given above. All you have to do is open Google Sheets on your Desktop and click on your desired sheet to open and edit it then enter the date in a particular cell. After writing the date select it and drag that particular cell till when you want to enter a date. On the other hand, in mobile, the process is the same just you have to copy the date and then you have to drag and click on Paste to paste it.
How to Add Date in Google Sheets – FAQs
How do I automate the current date in Google Sheets
By using the =Today() function you can automate the date in Google Sheets.
How do you auto increment dates in Google Sheets?
Using Dragging you can auto increment the dates, all you have to do is enter the initial date and drag it by selecting the corner of the initial date’s cell.
How do I autofill dates in Google Sheets without dragging?
You can autofill dates without dragging by entering the Array Formula with Sequence function such as “=ARRAYFORMULA(A1 + SEQUENCE(30, 1))“.
How do I create a date formula in Google Sheets?
Using “=Date” function you can create the date formula such as “=DATE(2023, 12, 31) // Creates the date December 31, 2023″
Contact Us