View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cam Cam is offline
external usenet poster
 
Posts: 165
Default Workday function not working

I did have ToolPak loaded from the add-in, but it didn't work.

"Mike H" wrote:

Hi,

Straight from E2003 help

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

Tools - Addins and then do what help says
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Cam" wrote:

Hello,

Why does it returns "#NAME?" when I use =WORKDAY function in Excel 2003?

My formula is =WORKDAY(D4,-B1,Holiday!A2:E109) where D4 is a date and B1 is
the number of days.

Any sugguestion, thank you.