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

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

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

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.


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