Skip to content

AutoFill Dates in Excel – Days, Weekdays, Months & Years

     

    In this video tutorial I look at quick ways of creating a list of dates.

    How to Create a List of Concurrent Dates

    Click here to view this part of the video

    To create a list of concurrent dates, follow these steps:

    1. Enter your starting date in a cell
    2. Select that cell (if not already selected)
    3. Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
    4. Hold down your left mouse button and drag down or across cells to create the list of dates

    How to Copy Dates

    Click here to view this part of the video

    To copy a date, follow these steps:

    1. Enter the date you want to copy in a cell
    2. Select that cell (if not already selected)
    3. Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
    4. Hold down your left mouse button and the CTRL key on your keyboard and then drag down or across cells to create the list of dates

    How to Create a List of Week Commencing Dates

    Click here to view this part of the video

    To create a list of week commencing dates (say every Monday – but this would work for any day of the week), follow these steps:

    1. Enter your first Monday date in a cell
    2. In the cell directly below (if creating a column of dates) or in the next cell to the right (if creating a row of dates) enter the first Monday date
    3. Select both cells that contain your Monday dates
    4. Place your mouse-pointer over the fill-handle (the small square, bottom-right of the second cell)
    5. Hold down your left mouse button and drag down or across cells to create the list of Monday dates

    Create a List of Weekdays (Excluding Saturdays and Sundays)

    Click here to view this part of the video

    To create a list of weekdays that exclude weekend dates, follow these steps:

    1. Enter your starting date in a cell
    2. Select that cell (if not already selected)
    3. Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
    4. Hold down your left mouse button and drag down or across cells to create the list of dates
    5. Click on the AutoFill Options button bottom-right of your selected dates
    6. Select Fill Weekdays from the list of fill options

    Create a List of Dates on the Same Day Each Month

    Click here to view this part of the video

    To create a list of dates on the same day each month, follow these steps:

    1. Enter your starting date in a cell
    2. Select that cell (if not already selected)
    3. Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
    4. Hold down your left mouse button and drag down or across cells to create the list of dates
    5. Click on the AutoFill Options button bottom-right of your selected dates
    6. Select Fill Months from the list of fill options

    Create a List of Dates on the Same Day Each Year

    Click here to view this part of the video

    To create a list of dates on the same day each year, follow these steps:

    1. Enter your starting date in a cell
    2. Select that cell (if not already selected)
    3. Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
    4. Hold down your left mouse button and drag down or across cells to create the list of dates
    5. Click on the AutoFill Options button bottom-right of your selected dates
    6. Select Fill Years from the list of fill options