How to Autofill Dates in MS Excel

Written by alyssa rodriquez
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Autofill Dates in MS Excel
Excel's Auto Fill feature can save you a lot of time. (business image by Magalice from Fotolia.com)

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

Other People Are Reading

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

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

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.