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!
>

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" <Diane1477@discussions.microsoft.com> wrote in message
news:A41583AC-94B0-4AEB-9C79-CE976623763F@microsoft.com...
> 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),MONTH(A4)+1,0)))

and copy all the way down thru B12


"Diane1477" <Diane1477@discussions.microsoft.com> wrote in message
news:A41583AC-94B0-4AEB-9C79-CE976623763F@microsoft.com...
> 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" <Diane1477@discussions.microsoft.com> wrote in message
news:6CDC9513-6AAA-491F-9640-EB198D4E7E8F@microsoft.com...
> 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),MONTH(A4)+1,0)))
>
> and copy all the way down thru B12
>
>
> "Diane1477" <Diane1477@discussions.microsoft.com> wrote in message
> news:A41583AC-94B0-4AEB-9C79-CE976623763F@microsoft.com...
> > 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!
> >
>
>
>