Try this:
A1 = start date
B1 = end date
C1:C10 = holiday dates to exclude***
=NETWORKDAYS(A1+1,B1+1,C1:C10)
*** Add 1 day to each holiday date. If 1/1/2007 (m/d/y) is a holiday enter
it as 1/2/2007.
Or, to avoid that confusion enter the actual holiday dates and add the 1 day
directly in the formula. That will make the formula an array and will need
to be entered using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):
=NETWORKDAYS(A1+1,B1+1,C1:C10+1)
Biff
"Excel Dubai" <Excel
wrote in message
...
I would like to know how many working days between 2 dates. BUT, the
networkdays function only takes into account SATURDAYS and SUNDAYS as week
end.
I live in a country where week ends are FRIDAYS and SATURDAYS...
Your help will be really appreciated.
Best Regards,
Marouane