If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Workday function not working
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. |
#2
|
|||
|
|||
Workday function not working
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Workday function not working
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. |
#5
|
|||
|
|||
Workday function not working
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. |
#6
|
|||
|
|||
Workday function not working
Hmmm,
I'm confused. email me the file to the address below with the obvious changes to the address and I'll take a look m.l.hughes at virginmedia.com -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Cam" wrote: 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. |
#7
|
|||
|
|||
Workday function not working
Did you guys solve this problem? I'm having the same issue. The cell will show #Value until i manually F2+enter in the cell. Once that is done, I won't have to do it again, until i close and restart the spreadsheet.
My formula is =Workday(today(),-2). Pretty standard. I use it everywhere. I've removed and readded in analysis toolpak and toolpak vba. When readding the formula will recalculate. It seems to me that excel is not aware of the add-in. --- frmsrcurl: http://msgroups.net/microsoft.public...on-not-working |
Thread Tools | |
Display Modes | |
|
|