NetWorkDays Function Syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the syntax to add more than one "holiday" for NetWorkDays function?
The below formula does not work:
=NETWORKDAYS(B2,C2,"1/1/05","1/17/05")

Do you have reference other cells with the dates that are suppose to be
excluded? Or can you manually enter dates into the function? Thank you
 
It needs to be in brackets...
=NETWORKDAYS(B2,C2,"1/1/05",{"1/17/05","1/18/05"})
 
Hi Lamar

Insert a list of public holiday dates, say in F1:F13 or whatever.
Your formula should then read =NETWORKDAYS(B2,C2,F1:F13)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NETWORKDAYS 1
Work Hours 1
NETWORKDAYS 1
Multi NetWorkDays Calculation 3
Networkdays to open previous day's file 3
Problem with NetworkDays ... Inconsistent results 0
returning a date 7 business day excluding holidays in the future 2
Networkday & workday with array functions 1

Back
Top