NETWORKDAYS Function

Use

NETWORKDAYS Function returns with a number of working days between two dates after excluding weekends and holidays.

Syntax

=NETWORKDAYS (start_date, end_date, [holidays])

where,

start_date – The start date

end_date – The end date

[holidays] – The optional argument, use to mention non-working days/ holidays.

Example

Formula:

Results:

Common Error

#VALUE! occurs when the supplied date is not valid.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved