How to Enter a Series of Dates in Excel That Are Only Weekdays

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. 

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Microsoft Office and tagged , , , , , . Bookmark the permalink.

One Response to How to Enter a Series of Dates in Excel That Are Only Weekdays

  1. Pingback: Excel:How to Enter Dates That Are Weekdays Only in a Series | SutoCom Solutions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s