WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

A free Office suite fully compatible with Microsoft Office

Free Download

How to Use the Workday Function in Excel?

June 26, 2023
513 Views

Excel's Workday function is a tool that helps you calculate the number of workdays between two dates, excluding weekends and any specified holidays. It's a powerful tool for anyone who needs to track working days, calculate project timelines, or manage vacation schedules. 

How to Use Excel Workday

Using Excel's Workday function is easy. Simply enter the start date, the number of days you want to add, and a list of holidays to exclude (if necessary). The Workday function will then calculate the end date, considering any weekends or holidays.

The basic formula for Workday is:

=WORKDAY(start_date,days,[holidays])

Where start_date is the starting date, days is the number of workdays you want to add or subtract, and holidays (optional) is a range of cells that contains the holidays you want to exclude from the calculation.

For example, if you wanted to calculate the date that's 30 workdays after January 1, 2022 (excluding New Year's Day and Martin Luther King Jr. Day), you can use the following formula:

=WORKDAY("1/1/2022",30,{"1/1/2022","1/17/2022"})

In this case, the result would be February 14, 2022 (since weekends and holidays are excluded from the calculation).

You can also use negative numbers for the days argument to subtract workdays from a date. For example, if you wanted to calculate the date that's 10 workdays before January 1, 2022 (excluding weekends and holidays), you would use the following formula:

=WORKDAY("1/1/2022",-10)

In this case, the result would be December 17, 2021.

Trustpilot

stars

4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User

avator

Algirdas Jasaitis

How to Use Excel Workday with Month Function

You can also use the Workday function with Excel's Month function. For example, if you wanted to calculate the last workday of each month for a given year, you could use the following formula:

=WORKDAY(EOMONTH("1/1/2022",0),-1)

In this case, EOMONTH returns the last day of the month for January 2022 (January 31), and then the Workday function calculates the last workday of the month by subtracting one workday from that date.

How to Exclude Holidays in Excel

You can exclude holidays from your Workday calculation using a range of cells that contains the holiday dates. For example, if you had a list of holidays in cells A1:A3, you could modify the formula like this:

=WORKDAY("1/1/2022",30,A1:A3)

In this case, the Workday function will exclude any dates in the range A1:A3 from the calculation.

Why You Should Choose WPS Office

The Excel Workday function is a powerful tool that can save you time and effort when calculating workdays between two dates or excluding holidays. With just a few simple steps, you can quickly and easily calculate workdays for project timelines, vacation schedules, or any other application where counting workdays is necessary.

If you're looking for a powerful and easy-to-use spreadsheet program, we recommend trying WPS Spreadsheet. With WPS Spreadsheet, you can use Excel's Workday function and many other powerful tools to make your work easier and more efficient. So why give it a try today?


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.