| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula became #NAME?
Hello,
I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula became #NAME?
You will probably need to re-install the Analysis Tool-pack add-in.
Hope this helps. Pete On Oct 1, 3:08*pm, Cam wrote: Hello, I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109)) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula became #NAME?
Try
Tools|Addins Select the analysis toolpak Mike "Cam" wrote: Hello, I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109)) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula became #NAME?
Thanks guy. I reinstall tool pack and worked ok.
"Pete_UK" wrote: You will probably need to re-install the Analysis Tool-pack add-in. Hope this helps. Pete On Oct 1, 3:08 pm, Cam wrote: Hello, I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109)) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula became #NAME?
You're welcome - thanks for feeding back.
Pete On Oct 1, 3:29*pm, Cam wrote: Thanks guy. I reinstall tool pack and worked ok. "Pete_UK" wrote: You will probably need to re-install the Analysis Tool-pack add-in. Hope this helps. Pete On Oct 1, 3:08 pm, Cam wrote: Hello, I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109))- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
