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!