Calculate elapsed working days

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

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

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

are you actually using

=IF(A:A="FTR",NETWORKDAYS(Q:Q,U:U))?

make it row specific, i.e. in row 2

=IF(A2="FTR",NETWORKDAYS(Q2,U2),"")

and copy down

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

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