EDATE formula works on one computer, not on another

We have a problem in the office that we can not figure out.

One worksheet, when opened on one computer works fine. When opened on another computer, an if statement with an EDATE function gives a NAME? error.
When I evaluate the error (Show Calculation Steps...) here is what is returned:
IF(40402, EDATE(D69, 1), "")
IF (TRUE, #NAME?,"")

There is definitely a date in D69 (as it serializes in the calculation steps). Just tested on a third, and it works fin on that one also.

I have no idea why this is happening. Any ideas?

You need to install the Analysis Tool Pack add-in.

lsutiger,

rather than deleting your original post and replacing it with "I figured this out", you could have posted what your solution was.

A forum is for exchange, so, you don't just grab what you can and run, but try to give something back. Others in a similar position may find your contributions useful.

Therefore, I've restored your original post.