How to Autofill Dates in MS Excel

By Alyssa Rodriquez

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.

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

Step 2

Enter the beginning date in the first cell. Enter the formula =[cell1]+[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."

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