Calculate elapsed working days

Andy:

Thanks so much for pointing out the error of my ways. I was trying to calc
the whole column at once, when what I really needed to do, was to calculate
each row individually, then do my averaging.

Thanks again for all your help!
Sandi ;-)

"Andy" wrote:

> What are you trying to achieve? Are you wanting a resul for each cell, or
> the whole column at once?
> If it's for each cell, use this in AC2
> =IF(A2="FTR",NETWORKDAYS(Q2,U2))
> and fill it down the column.
>
> Hope this helps.
> Andy.
>
> "RUSH2CROCHET" <RUSH2CROCHET@discussions.microsoft.com> wrote in message
> news:3F6E3626-777C-46E0-864D-869B8C1612D7@microsoft.com...
> > Andy:
> >
> > My analysis toolpak is loaded.... What next?
> >
> > Sandi
> >
> > "Andy" wrote:
> >
> >> Hi
> >>
> >> I think NETWORKDAYS is part of the Analysis toolpak, so make sure that is
> >> loaded in Tools/Add-ins.
> >>
> >> Andy.
> >>
> >> "RUSH2CROCHET" <RUSH2CROCHET@discussions.microsoft.com> wrote in message
> >> news:FE0485F5-5EB9-484A-AA84-ACC5D55888E6@microsoft.com...
> >> > Hello everyone:
> >> >
> >> > I have a worksheet of order transactions which my group processes. I
> >> > would
> >> > like to determine for FTR's the
> >> > # of work days elapsed between Fax Date & Approval Date.
> >> >
> >> > Column A represents the type of transaction (FTR, Purchase,
> >> > Rental,etc.)
> >> > Column Q is Fax Date
> >> > Column U is Approval Date
> >> >
> >> > I have placed the following in Column AC:
> >> >
> >> > =IF(A:A="FTR",DAYS360(Q:Q,U:U))
> >> >
> >> > This works fine, yet when I put NetworkDays in place of Days360, it
> >> > returns
> >> > #NUM!
> >> >
> >> > Can someone please give me guidance? All help appreciated!
> >> >
> >> > TIA,
> >> > Sandi
> >>
> >>
> >>
>
>
>

It was a pleasure! Thanks for the feedback!

Andy.

"RUSH2CROCHET" <RUSH2CROCHET@discussions.microsoft.com> wrote in message
news:18D26050-4382-4D77-8BC9-4D1BCD93C957@microsoft.com...
> Andy:
>
> Thanks so much for pointing out the error of my ways. I was trying to calc
> the whole column at once, when what I really needed to do, was to
> calculate
> each row individually, then do my averaging.
>
> Thanks again for all your help!
> Sandi ;-)
>
> "Andy" wrote:
>
>> What are you trying to achieve? Are you wanting a resul for each cell, or
>> the whole column at once?
>> If it's for each cell, use this in AC2
>> =IF(A2="FTR",NETWORKDAYS(Q2,U2))
>> and fill it down the column.
>>
>> Hope this helps.
>> Andy.
>>
>> "RUSH2CROCHET" <RUSH2CROCHET@discussions.microsoft.com> wrote in message
>> news:3F6E3626-777C-46E0-864D-869B8C1612D7@microsoft.com...
>> > Andy:
>> >
>> > My analysis toolpak is loaded.... What next?
>> >
>> > Sandi
>> >
>> > "Andy" wrote:
>> >
>> >> Hi
>> >>
>> >> I think NETWORKDAYS is part of the Analysis toolpak, so make sure that
>> >> is
>> >> loaded in Tools/Add-ins.
>> >>
>> >> Andy.
>> >>
>> >> "RUSH2CROCHET" <RUSH2CROCHET@discussions.microsoft.com> wrote in
>> >> message
>> >> news:FE0485F5-5EB9-484A-AA84-ACC5D55888E6@microsoft.com...
>> >> > Hello everyone:
>> >> >
>> >> > I have a worksheet of order transactions which my group processes.
>> >> > I
>> >> > would
>> >> > like to determine for FTR's the
>> >> > # of work days elapsed between Fax Date & Approval Date.
>> >> >
>> >> > Column A represents the type of transaction (FTR, Purchase,
>> >> > Rental,etc.)
>> >> > Column Q is Fax Date
>> >> > Column U is Approval Date
>> >> >
>> >> > I have placed the following in Column AC:
>> >> >
>> >> > =IF(A:A="FTR",DAYS360(Q:Q,U:U))
>> >> >
>> >> > This works fine, yet when I put NetworkDays in place of Days360, it
>> >> > returns
>> >> > #NUM!
>> >> >
>> >> > Can someone please give me guidance? All help appreciated!
>> >> >
>> >> > TIA,
>> >> > Sandi
>> >>
>> >>
>> >>
>>
>>
>>