Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


Fill a date series in Excel (even if only workdays)

Creating a listing of dates is a common Excel requirement. You want to enter the first date and then drag down so that it fills in the next dates. But what if you want it to only fill a date series in Excel which contains workdays only?

YouTube Fill down date series (daily, weekday, month, year!)

Fill a normal date series in Excel

In order to activate the Fill Series in Excel you need to

  1. Have something in the cell (below we have a date),
  2. Hover your cursor over the bottom right (as if you are going to copy it)
  3. BUT you right click and drag down.
Fill a date series in Excel

As you drag down you will see that it will suggest consecutive dates.

Fill a date series in Excel

When you let go this will appear.

Fill a date series in Excel

Note that you have a number of choices. If we choose Fill Days then it will just follow consecutively.

Fill with the Workday Series only

You may have already seen how easy it is to do this. Follow the exact same steps as above except choose ‘Fill Weekdays’

Fill a date series in Excel

The end result is as follows. Note that at the Friday it skips the weekend and goes straight to the Monday.

Fill with a Month or Year Series

If you choose one of the other options it would create that series. Using the same start date below we show what each would look like i.e.

  • Days- consecutive days from the start date
  • Workdays- consecutive WORKDAYS from the start date (even if the start date is not a workday)
  • Months- consecutive months from the start date
  • Years- consecutive years from the start date

Want to learn more about Microsoft Excel? If you prefer live courses and live in South Africa look at the MS Excel training courses available. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

Excel Date difference- how to calculate

Date Axis in Excel Chart is wrong

Excel Date difference- how to calculate

Fixing date format or sort issues in Excel