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

On Thu, 9 Mar 2006 15:19:33 -0600, lsmft
wrote:


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?


You need to install the Analysis ToolPak.

See HELP for the WORKDAY function and it will tell you what to do when you see
a #NAME error
--ron