# How to Autofill Dates in MS Excel

Written by alyssa rodriquez
• Share
• Tweet
• Share
• Pin
• Email

Microsoft Excel is a program that many businesses use to create spreadsheets. Spreadsheets can be tedious to set up if you have to enter a large list of dates. Microsoft Excel's Auto Fill feature makes it easy to insert a series of dates into a worksheet.

Skill level:
Easy

## Instructions

1. 1

Enter the beginning date in the first cell. Using your mouse, grab the Auto Fill handle (the black square in the bottom-left corner of the cell) and pull across a column or row to fill the column or row with sequential dates.

For example, enter "1/1/01" into cell "A1." Drag "A1's" Auto Fill handle to cell "A3." Cells "A2" and "A3" will auto-fill with "1/2/01" and "1/3/01."

2. 2

Enter the beginning date in the first cell. Enter the formula =[cell 1]+[number of days] into the second cell. Grab the second cell's Auto Fill handle and pull across a column or row to fill the column or row with the series of dates.

For example, enter "1/1/01" into cell "A1." Enter "=A1+7" into cell "A2." Cell "A2" will auto-fill with "1/8/01" Drag "A2's" Auto Fill handle to cell "A4." Cells "A3" and "A4," will auto-fill with "1/15/01" and "1/22/01."

3. 3

Enter enough dates to establish a pattern if you have a series of dates that have irregular intervals of days. Select all the cells that you entered dates into. Grab the Auto Fill handle and pull across a column or row to fill the column or row with the series of dates.

For example, enter "1/1/01" into cell "A1." Enter "2/1/01" into cell "A2." Click on "A1" and pull to "A2" so they are both selected. Pull the Auto Fill handle to cell "A4." Cells "A3" and "A4," will auto-fill with "3/1/01" and "4/1/01."

#### Tips and warnings

• If the auto-filled cells show "#####" then the cells aren't big enough. Adjust the column width to allow enough space to display the date.

### Don't Miss

#### References

• All types
• Articles
• Slideshows
• Videos
##### Sort:
• Most relevant
• Most popular
• Most recent