Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays. 

All you have to do is enter the start date and then drag using the right mouse button. This works on all versions for Windows and Mac. 

Here’s a short video showing you how it works.