MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Use WORKDAY.INTL for a Work Calendar

July 29, 2020 - by Bill Jelen

Excel Use WORKDAY.INTL for a Work Calendar. Photo Credit: Colin Carter at

While NETWORKDAYS calculates the work days between two dates, the WORKDAY function takes a starting date and a number of days, and it calculates the date that is a certain number of work days away.

One common use is to calculate the next work day. In the following figure, the start date is the date on the previous row. The number of days is always 1. To generate a class schedule that meets on Monday, Wednesday, and Friday, specify a weekend of "0101011".

You want to fill dates for Monday, Wednesday and Friday. Type the first date in A2. Below that, use =WORKDAY.INTL(A2,1,"0101011"). This says to start from the date in A2, go out 1 day, based on a work week where Tuesday, Thursday, Saturday and Sunday are the weekends.

Title Photo: Colin Carter at

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.