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

Calculate elapsed working days
 

Hi

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

Andy.

"RUSH2CROCHET" wrote in message
...
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

Calculate elapsed working days
 

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" wrote in message
...
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

Calculate elapsed working days
 

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" wrote in message
...
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" wrote in message
...
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

Calculate elapsed working days
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=520729

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" wrote in message
...
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" wrote in message
...
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

Calculate elapsed working days
 

It was a pleasure! Thanks for the feedback!

Andy.

"RUSH2CROCHET" wrote in message
...
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" wrote in message
...
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" wrote in
message
...
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