Skip to content

Create a Series of Only Weekdays in Excel

Here is the problem you are trying to solve. You are trying to create a list of only weekdays in Excel.

The task is simple, but how do you create a list that only includes weekdays and no weekends? This article will show you how!

What You Might Be Doing

As you approach this task, your first idea might be to try and use the fill handle like this.

Type in a few dates in sequential order.

Highlight the cells with dates.

Use the fill handle to drag the dates down to generate your list.

The problem with this approach is that you now have a list of dates that include weekends and weekdays. From this point on, you will have to deal with the weekend dates by either deleting them or moving them out of the way.

Dealing with this new problem is certainly not the most efficient way to go about things.

What You Should Do Instead

Instead of taking the approach described above, here is a much faster and more efficient way to create a list of only weekdays.

Start by selecting the cell that starts your list and use the keyboard shortcut below.

CTRL + ;

This keyboard shortcut will input the current date into the selected cell. Also, if you want to start your list with some other date, you can type in that date instead.

Make you the active cell contains the date you just added and go to Home > Fill > Series in the Excel Ribbon.

The Series dialog box will appear.

Select ColumnsDate, and Weekday.

Input where you want your date list to stop under Stop value.

Go ahead and click Ok, and now you have a list of all weekdays without any weekends included.

How awesome is that!?

If you enjoyed this article and have any suggestions for tips and tricks or other articles you would like to see, leave us a comment below to let us know.

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top