Excel – How can I create a list of Weekdays only?

Need a list of weekdays?  The Auto Fill button allows us to quickly create a lists of days of the week.  However, the list includes Saturday and Sunday.   Thankfully Excel offers a very simple solution to create a list that only includes Weekdays.

To quickly create a list of Weekdays only:

  1. First type in your starting date.
  2. Now click and drag the Auto Fill button to display dates going forward.
  3. When you release the mouse button Excel will display the Auto Fill Options box.
  4. Click the drop-down arrow on the box and then select Fill Weekdays.
  5. Excel will remove any dates that fall in the weekend and only dates for week days will be displayed.

We cover many more fabulous time saving tips and features in our Excel Stage 1 half-day and full day training courses.

If you found this post helpful please ‘Like’ us!

Facebook
Facebook
Twitter
Google+
Google+
http://excelatwork.co.nz/2013/11/02/excel-how-can-i-create-a-list-of-weekdays-only