edate function

[Candace]

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]

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

 

[Barry]

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