View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default count work days excluding Fridays and Saturdays ???

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