count work days excluding Fridays and Saturdays ???

E

Excel Dubai

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
 
T

T. Valko

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
 
J

joeu2004

I would like to know how many working days between 2 dates. BUT, the
networkdays function only takes into account SATURDAYS and SUNDAYS as
weekend. I live in a country where week ends are FRIDAYS and SATURDAYS

The following is a general solution that will permit you count the
number of any set of days of the week, not just the 5 consecutive days
excluding 2 "weekend" days:

=SUMPRODUCT(--(WEEKDAY(A1-1+ROW(INDIRECT("a1:a"&A2-
A1+1)))={1,2,3,4,5}))

The above assumes that A1 is the start date and A2 is the end date.

The constant {1,2,3,4,5} represents Sunday through Thursday. But, for
example, if you replace it with {6,7}, the formula will count the
number of "weekend" days, assuming they are Friday and Saturday.
 
D

daddylonglegs

This formula will also give the sam result, although, of course, it doesn't
take account of holidays

=SUM(INT((WEEKDAY(A1-{1,2,3,4,5})+A2-A1)/7))
 

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

Top