NETWORKDAYS Function returns with a number of working days between two dates after excluding weekends and holidays.
=NETWORKDAYS (start_date, end_date, [holidays])
start_date – The start date
end_date – The end date
[holidays] – The optional argument, use to mention non-working days/ holidays.
#VALUE! occurs when the supplied date is not valid.