Help with week day count with range
 

My data is:

First Date 3/9/05
Last Date 5/12/05


Month Workdays*
February-05
March-05
April-05
May-05
June-05
July-05
August-05

I need to calculate the number of avialble work days per month, but I also
need to have the formula adjust to account for the start and end dates.

In the above example is there a formula to calculate:

March-05 (Number of weekdays in March (subtracting the week days
excluded by the start date)
April-05 (Number of weekdays in April)
May-05 (Number of weekdays in May (subtracting the weekdays
excluded by the end date)

I don't know how to creat the proper IF statement or weekday formula.

Please Help!

Check out the networkdays() function

"Diane1477" wrote:

My data is:

First Date 3/9/05
Last Date 5/12/05


Month Workdays*
February-05
March-05
April-05
May-05
June-05
July-05
August-05

I need to calculate the number of avialble work days per month, but I also
need to have the formula adjust to account for the start and end dates.

In the above example is there a formula to calculate:

March-05 (Number of weekdays in March (subtracting the week days
excluded by the start date)
April-05 (Number of weekdays in April)
May-05 (Number of weekdays in May (subtracting the weekdays
excluded by the end date)

I don't know how to creat the proper IF statement or weekday formula.

Please Help!

Assuming that the start date is on cell A1 and end date on cell A2
and all your months are listed from A4 thru A12 like
1/1/05
2/1/05
....

On cell B4 type
=NETWORKDAYS(MAX(A4,$A$1),MIN($A$2,DATE(YEAR(A4),M ONTH(A4)+1,0)))

and copy all the way down thru B12


"Diane1477" wrote in message
...
My data is:

First Date 3/9/05
Last Date 5/12/05


Month Workdays*
February-05
March-05
April-05
May-05
June-05
July-05
August-05

I need to calculate the number of avialble work days per month, but I also
need to have the formula adjust to account for the start and end dates.

In the above example is there a formula to calculate:

March-05 (Number of weekdays in March (subtracting the week days
excluded by the start date)
April-05 (Number of weekdays in April)
May-05 (Number of weekdays in May (subtracting the weekdays
excluded by the end date)

I don't know how to creat the proper IF statement or weekday formula.

Please Help!

Hi

Have a look at the NETWORKDAYS function. It might be part of the Analysis
toolpak (or even the VBA analysis toolpak). I think it will do what you
want.

Andy.

"Diane1477" wrote in message
...
My data is:

First Date 3/9/05
Last Date 5/12/05


Month Workdays*
February-05
March-05
April-05
May-05
June-05
July-05
August-05

I need to calculate the number of avialble work days per month, but I also
need to have the formula adjust to account for the start and end dates.

In the above example is there a formula to calculate:

March-05 (Number of weekdays in March (subtracting the week days
excluded by the start date)
April-05 (Number of weekdays in April)
May-05 (Number of weekdays in May (subtracting the weekdays
excluded by the end date)

I don't know how to creat the proper IF statement or weekday formula.

Please Help!

It only works with two specific dates. I need a combination function of
networkdays and an IF statement. Do you know of one?

"bj" wrote:

Check out the networkdays() function

"Diane1477" wrote:

My data is:

First Date 3/9/05
Last Date 5/12/05


Month Workdays*
February-05
March-05
April-05
May-05
June-05
July-05
August-05

I need to calculate the number of avialble work days per month, but I also
need to have the formula adjust to account for the start and end dates.

In the above example is there a formula to calculate:

March-05 (Number of weekdays in March (subtracting the week days
excluded by the start date)
April-05 (Number of weekdays in April)
May-05 (Number of weekdays in May (subtracting the weekdays
excluded by the end date)

I don't know how to creat the proper IF statement or weekday formula.

Please Help!

Hi

If NETWORKDAYS does not suffice, you'd better post your question a bit more
clearly - as we've all got the wrong end of the stick!

Andy.

"Diane1477" wrote in message
...
It only works with two specific dates. I need a combination function of
networkdays and an IF statement. Do you know of one?

"bj" wrote:

Check out the networkdays() function

"Diane1477" wrote:

My data is:

First Date 3/9/05
Last Date 5/12/05


Month Workdays*
February-05
March-05
April-05
May-05
June-05
July-05
August-05

I need to calculate the number of avialble work days per month, but I
also
need to have the formula adjust to account for the start and end dates.

In the above example is there a formula to calculate:

March-05 (Number of weekdays in March (subtracting the week days
excluded by the start date)
April-05 (Number of weekdays in April)
May-05 (Number of weekdays in May (subtracting the weekdays
excluded by the end date)

I don't know how to creat the proper IF statement or weekday formula.

Please Help!

It worked! Thank you so much!

"N Harkawat" wrote:

Assuming that the start date is on cell A1 and end date on cell A2
and all your months are listed from A4 thru A12 like
1/1/05
2/1/05
....

On cell B4 type
=NETWORKDAYS(MAX(A4,$A$1),MIN($A$2,DATE(YEAR(A4),M ONTH(A4)+1,0)))

and copy all the way down thru B12


"Diane1477" wrote in message
...
My data is:

First Date 3/9/05
Last Date 5/12/05


Month Workdays*
February-05
March-05
April-05
May-05
June-05
July-05
August-05

I need to calculate the number of avialble work days per month, but I also
need to have the formula adjust to account for the start and end dates.

In the above example is there a formula to calculate:

March-05 (Number of weekdays in March (subtracting the week days
excluded by the start date)
April-05 (Number of weekdays in April)
May-05 (Number of weekdays in May (subtracting the weekdays
excluded by the end date)

I don't know how to creat the proper IF statement or weekday formula.

Please Help!