View Single Post
  #8   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Thu, 10 Mar 2005 15:59:02 -0800, "Monique"
wrote:

Have you tried the formula you are giving me in an actual cell in Excel? I
put it in and get a #Name? error.


Your writing of exactly what happens when you try to use the formula is most
helpful in troubleshooting.

Again, from HELP for the WORKDAY function, it seems to describe your issue:

===========================
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.
================================

Seems like you need to install the Analysis ToolPak, doesn't it?


--ron