WORKDAYS

Calculates the number of workdays between two dates

WORKDAYS(start, end, [holidays])

Returns the number of weekdays between two dates

Arguments

Argument	Description
start date	Date/time value(s) corresponding to start date
end date	Date/time value(s) corresponding to end date
holidays	List of dates to exclude from the count of weekdays

Outputs

Number of weekdays between start date and end date, excluding any dates included in holidays.

Example