View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RUSH2CROCHET
 
Posts: n/a
Default 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