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 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.