Calculate no of days between dates, including weekends, excluding Holidays

[nparsons75]

I need to calculate the number of days between two dates, including weekends but excluding holidays. I have a table listing the holiday dates named 'holidays'.

Thanks

 

[FormR]

Hi, take a look at NETWORKDAYS.INTL - i.e.

=NETWORKDAYS.INTL(StartDate,EndDate,"0000000",Holidays)

 

[nparsons75]

Hi, I seen something like this, what does the "000000" do?

update,

Whatever it does, it works, thank you very much...

 

[FormR]

what does the "000000" do?

Hi, the below quote is taken from here:

https://support.office.com/en-us/ar...function-a9b26239-4f20-46a1-9ab8-4e925bfd5e28

Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday. 1 represents a non-workday and 0 represents a workday. Only the characters 1 and 0 are permitted in the string. Using 1111111 will always return 0.


For example, 0000011 would result in a weekend that is Saturday and Sunday