How do I get networkdays for a month

P

pbs

If I have a date range of 4/15 - 7/30, how do I pull out the workdays per
month?

April - #
May - #
June - #
July - #

Thanks,
-pete
 
P

Peo Sjoblom

April

=NETWORKDAYS(DATE(2005,4,15),DATE(2005,4,30),Holidays)

adapt to fit for the rest



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
P

pbs

Thanks Peo. I think I need to be more clear in what I'm asking.

What I want to come out with is something like this:

April | May | June | July
4/15/2005 | 7/15/2005 12 20 22 10
6/15/2005 | 7/31/2005

I've tried this:
MAX(0,NETWORKDAYS(MAX(T$1,$E4),MIN(DATE(YEAR(T$1),MONTH(T$1)+1,0),$F4)))
But it is coming up 2 days short...

Any help would be appreciated.
 
D

Daniel.M

Hi,

With
A2: start date
B2: end date
holidays: your range of holidays (omit from formula if you have none)

C1: 1st Jan
D1: 1st Feb
drag until O1 (1st Jan next Year)

In C2: =MAX(0,NETWORKDAYS(MAX(C$1,$A2),MIN(D$1-1,$B2),holidays))

Copy C2 till N2

Obviously, your year can start in April (1st Apr in C1, 1st May in D1, etc.) and
the logic stays the same.

Daniel M.
 
Top