Table of Contents
AutoFill is a feature in Google Sheets that allows users to quickly generate a series of dates. To use AutoFill, simply enter a starting date in a cell and then click and drag the small blue square in the bottom right corner of the cell. This will automatically populate the adjacent cells with the next sequential dates. This feature is useful for quickly creating a timeline or calendar in a spreadsheet without having to manually enter each date. Additionally, users can customize the AutoFill feature to generate dates in different formats, such as weekdays only or skipping weekends.
AutoFill Dates in Google Sheets (3 Examples)
Often you may want to autofill dates in Google Sheets. Fortunately this is easy to do using the simple drag and fill feature built into Google Sheets.
The following examples show how to autofill dates in Google Sheets in practice.
Example 1: AutoFill Days in Google Sheets
To autofill a list of days in Google Sheets, simply type in one date to start:
Then hover over the bottom right-hand corner of the cell until a tiny “+” appears. Then click and drag down to however many cells you’d like in the same column:
The result is a list of consecutive days.
Example 2: AutoFill Weeks in Google Sheets
To autofill a list of weeks in Google Sheets, simply type in two dates that are exactly one week apart:
Then highlight both cell A1 and cell A2, then hover over the bottom right-hand corner of cell A2 until a tiny “+” appears.
Then click and drag down to however many cells you’d like in the same column:
The result is a list of consecutive weeks.
Example 3: AutoFill Months in Google Sheets
To autofill a list of months in Google Sheets, simply type in two dates that are exactly one month apart in cells A1 and A2.
Then click and drag down to however many cells you’d like in the same column:
The result is a list of consecutive months.
The following tutorials explain how to perform other common operations with dates in Google Sheets:
Cite this article
stats writer (2024). How can I use AutoFill to quickly generate dates in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-autofill-to-quickly-generate-dates-in-google-sheets/
stats writer. "How can I use AutoFill to quickly generate dates in Google Sheets?." PSYCHOLOGICAL SCALES, 16 May. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-autofill-to-quickly-generate-dates-in-google-sheets/.
stats writer. "How can I use AutoFill to quickly generate dates in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-autofill-to-quickly-generate-dates-in-google-sheets/.
stats writer (2024) 'How can I use AutoFill to quickly generate dates in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-autofill-to-quickly-generate-dates-in-google-sheets/.
[1] stats writer, "How can I use AutoFill to quickly generate dates in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, May, 2024.
stats writer. How can I use AutoFill to quickly generate dates in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.