edate function

I use the edate function in my model to calc 1 month in advance. It was
working fine until I was upgraded to Excel 2003. Now the formula returns a
#NAME? error. The Analysis ToolPak and Analysis ToolPak - VBA are enabled.
Does anyone know how to correct it?

If you just select one of those cells with the formula, hit F2, then enter, does
the error go away?

If yes, try:
selecting all the cells
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

If the error doesn't go away, double check the addins (just in case).

If the error is still there, you may want to post the formula--maybe it's not
the =edate() that's causing the trouble????

Candace wrote:
>
> I use the edate function in my model to calc 1 month in advance. It was
> working fine until I was upgraded to Excel 2003. Now the formula returns a
> #NAME? error. The Analysis ToolPak and Analysis ToolPak - VBA are enabled.
> Does anyone know how to correct it?

--

Dave Peterson

Make sure the date field you are referencing is not defined as a text field,
it must be in date format

"Candace" wrote:

> I use the edate function in my model to calc 1 month in advance. It was
> working fine until I was upgraded to Excel 2003. Now the formula returns a
> #NAME? error. The Analysis ToolPak and Analysis ToolPak - VBA are enabled.
> Does anyone know how to correct it?