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.

"Peo Sjoblom" wrote:

April

=NETWORKDAYS(DATE(2005,4,15),DATE(2005,4,30),Holid ays)

adapt to fit for the rest



--
Regards,

Peo Sjoblom

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



"pbs" wrote in message
...
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