NETWORKDAYS takes threearguments:start_date,end_date, andholidays.
All three arguments must be valid Excel dates.
To exclude holidays, provide a range ofvalid Excel datesfor theholidaysargument.
Holidays are treated as non-working days and will not be included in the result.
NETWORKDAYS includes both the start date and end date when calculating workdays.
Columns E and F show the number of working days in each month of the year.
This behavior is not configurable.
The DATEDIF (Date + Dif) function is a “compatibility” function that comes from Lotus 1-2-3.
Excel won’t help you fill out the arguments for DATEDIF like other functions, but it will work…
