View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Business Days Only

Try WORKDAY instead of WORDAY!

Andy.

"lsmft" wrote in
message ...

Andy,
In cell A1 I put 01/01/06
In cell B1 I put =WORDAY(A1,1)
All I'm getting is #NAME?
When I click and drag, I drag #NAME? horizontally across row 1.
Am I doing something wrong here?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=520746