Calculate elapsed working days

[Guest]

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

 

[Guest]

Hi

I think NETWORKDAYS is part of the Analysis toolpak, so make sure that is
loaded in Tools/Add-ins.

Andy.

 

[Guest]

Andy:

My analysis toolpak is loaded.... What next?

Sandi

 

[Guest]

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.

 

[daddylonglegs]

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

 

[Guest]

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

 

[Guest]

It was a pleasure! Thanks for the feedback!

Andy.