Table of Contents
The AutoFill feature in Microsoft Excel can save you time and energy when you’re entering data. It can quickly fill a series of cells with data, such as dates, making it easy to create a timeline or schedule. There are three simple ways to use AutoFill for dates in Excel: using the Fill Handle, the Fill Weekdays feature, and the Series command. With these methods, you can quickly and easily fill cells with dates in your Excel worksheet.
Often you may want to autofill dates in Excel. Fortunately this is easy to do using the simple drag and fill feature built into Excel.
The following examples show how to autofill dates in Excel in practice.
Example 1: AutoFill Days in Excel
To autofill a list of days in Excel, 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 Excel
To autofill a list of weeks in Excel, simply type in two dates that are exactly one week apart:
Highlight cells A2 and A3. Then hover over the bottom right-hand corner of cell A3 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 Excel
Highlight cells A2 and A3. Then hover over the bottom right-hand corner of cell A3 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 months.
The following tutorials explain how to perform other common operations with dates in Excel: