Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to create a list of weekdays/business days in Excel?

This tutorial is talking about how to create a list of weekdays between a date range in Excel, if you are interested in this, just go down to read the details.

List weekdays with Auto Fill Options

List weekdays with a handy tool -- Kutools for Excel


arrow blue right bubble List weekdays with Auto Fill Options


In Excel, you can list weekdays with the Autofill handle and choose the Fill Weekdays option.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

1. Type the start date you need in a blank cell. See screenshot:

doc list weekdays 1

2. Then drag the right corner of the date cell down to auto fill the dates. See screenshot:

Tip: You need to know how many weekdays (cells) you need. Here I need to list probably 22 weekdays.

doc list weekdays 2

3. Then you can click the Auto Fill Options to show the context menu, and check Fill Weekdays option. See screenshot:

doc list weekdays 3

Now you can see all 22 weekdays start from 7/1/2015 are list.

doc list weekdays 4

But this method is not convenient to quickly list business days between two dates, to save much working time, you can refer to next method.


arrow blue right bubble List weekdays with a handy tool -- Kutools for Excel

If you have Kutools for Excel installed, you can use the Insert Random Data to insert all weekdays or weekends between a dates range, and then sort the date as you need.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

1. Select a cells range (you’d better select much more cells than the dates you need to list). See screenshot:

doc list weekdays 5

2. Click Kutools > Insert > Insert Random Data. See screenshot:

doc list weekdays 6

3. In the Insert Random Data dialog, click Date tab, then type the start date in the From box, type the end date in the To box, and check Workday option and Unique Values option. See screenshot:

doc list weekdays 7

4. Click Ok or Apply, now all the weekdays of July have been inserted. See screenshot:

Tip: If the cells you selected are more than the inserted dates, there will be some blank cells left.

doc list weekdays 8

5. Go to Data > Sort Oldest to Newest to sort the dates from old to new. See screenshot:

doc list weekdays 9

Now the weekdays are listing from oldest to newest.

doc list weekdays 10

With Insert Random Data, you can quickly insert random integers, random time, random date, random unique values, random string and random custom list. Click here to know more about this utility.

Click here to free download Kutools for Excel


good ideaCurrency Conversion

Kutools'Currency Conversion function give you the last currency rate, and help you convert between multuple currencies.
Click Kutools > Content > Currency Conversion to quickly convert between two currencies. See screenshot:
doc currency conversion 1


Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.