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:
- Enter your starting date in a cell
- Select that cell (if not already selected)
- Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
- 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:
- Enter the date you want to copy in a cell
- Select that cell (if not already selected)
- Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
- 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:
- Enter your first Monday date in a cell
- 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
- Select both cells that contain your Monday dates
- Place your mouse-pointer over the fill-handle (the small square, bottom-right of the second cell)
- 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:
- Enter your starting date in a cell
- Select that cell (if not already selected)
- Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
- Hold down your left mouse button and drag down or across cells to create the list of dates
- Click on the AutoFill Options button bottom-right of your selected dates
- 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:
- Enter your starting date in a cell
- Select that cell (if not already selected)
- Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
- Hold down your left mouse button and drag down or across cells to create the list of dates
- Click on the AutoFill Options button bottom-right of your selected dates
- 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:
- Enter your starting date in a cell
- Select that cell (if not already selected)
- Place your mouse-pointer over the fill-handle (the small square, bottom-right of the cell)
- Hold down your left mouse button and drag down or across cells to create the list of dates
- Click on the AutoFill Options button bottom-right of your selected dates
- Select Fill Years from the list of fill options