NETWORKDAYS(start_date, end_date, list_holidays)

The NETWORKDAYS function calculates the number of whole work days between 2 dates, start_date and end_date, taking into account weekends and holidays.

For example, the formula

NETWORKDAYS ("1 Jan 1997", "31 Dec 1997") 

returns 261, that is a year’s worth of workdays, taking into account weekends.

NETWORKDAYS ("1 Jan 97", "31 Jan 97", "14 Jan 97", "15 Jan 97") 

returns 21, that is the number of workdays in January with two days holiday.

See also:

Other date functions