Workday function not working
in [Functions]
|
From: Cam on 17 Feb 2010 10:29 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.
From: Mike H on 17 Feb 2010 10:34 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.
From: Cam on 17 Feb 2010 10:38 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.
From: Mike H on 17 Feb 2010 10:50 Hi, As posted and with the ATP loaded your formula works fine so try this Check again you have loaded the correct ATP. You want the Analysis Toolpak and not the Analysis Toolpak VBA Check the spelling of your formula and to be sure paste the one in from your first post because we know that's correct. lastly select the cell with the formula and tap F2 and then press enter -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Cam" wrote: > 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.
From: Cam on 17 Feb 2010 11:19 Hi Mike, I did exactly what you suggested and it still didn't work. I have both Analysis Toolpak & Analysis Toolpak VBA selected. What else can I do? Thanks "Mike H" wrote: > Hi, > > As posted and with the ATP loaded your formula works fine so try this > > Check again you have loaded the correct ATP. You want the Analysis Toolpak > and not the Analysis Toolpak VBA > > Check the spelling of your formula and to be sure paste the one in from your > first post because we know that's correct. > > lastly select the cell with the formula and tap F2 and then press enter > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Cam" wrote: > > > 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.
|
Next
|
Last
Pages: 1 2 Prev: Pulling Data from one worksheet into another Next: Excel files take long time to open |