how to chenge to hollydays!

hi there ;
i live in israel , here the hollydays are friday& saterday;
im trying to count the workdays between 2 dates ,
the problem is the function DAYS360() doesn't returns the
correct answer cuase in the excell sunday is a hollyday
not saterday so , how can i change the hollyday definition
in this function , or do u have another idia to do this ?
i will be glad to have any solution , thanx for u all

:confused:

Originally Posted by someone_else

hi there ;
i live in israel , here the hollydays are friday& saterday;
im trying to count the workdays between 2 dates ,
the problem is the function DAYS360() doesn't returns the
correct answer cuase in the excell sunday is a hollyday
not saterday so , how can i change the hollyday definition
in this function , or do u have another idia to do this ?
i will be glad to have any solution , thanx for u all

You can use NETWORKDAYS function.

Normally, if your start date is A1 and end date B1 you'd use

=NETWORKDAYS(A1,B1)

which counts A1 to B1 inclusive, not including Saturdays or Sundays. To change to exclude Fridays and Saturdays try

=NETWORKDAYS(A1+1,B1+1)

NETWORKDAYS function is part of Anaylsis ToolPak addin. If formula doesn't work you may need to install the addin. Use Tools > addins > tick Analysis ToolPak box