Use NETWORKDAYS(start,end,[holidays])
[holidays] is an optional range of holidays to exclude.
The equation returns the number of days between the dates inclusive of the dates so for your dates, the function returns 5 (without accounting for holidays).
|