Holidays - an optional list of dates that should not to be counted as working days.A positive number returns a future date, a negative number returns a past date.
The first 2 arguments are required and the last one is optional: In Excel 2010 and higher, more powerful modifications of the above-said functions are available, WORKDAY.INTL and NETWORKDAYS.INTL, which let you define which and how many days are weekend days.Īnd now, let's have a closer look at each function and see how you can use it to calculate working days in your Excel worksheets. Using the NETWORKDAYS function, you can calculate the number of workdays between two dates that you specify. The WORKDAY function returns a date N working days in the future or in the past and you can use it to add or subtract workdays to a given date. Microsoft Excel provides two functions specially designed for calculating weekdays - WORKDAY and NETWORKDAYS.
This short tutorial explains the use of Excel NETWORKDAYS and WORKDAY functions to calculate workdays with custom weekend parameters and holidays.
