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 -
|