Excel 2019: Use WORKDAY.INTL for a Work Calendar
July 25, 2019 - by Bill Jelen
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".
Title Photo: Colin Carter at Unsplash.com