edate function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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????
 
Make sure the date field you are referencing is not defined as a text field,
it must be in date format
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

edate - Prior to Excel 2003 3
EDATE Function disappears intermittently 1
No Analysis Tool Pack=EDATE formula not working! HELP!! 8
Array Function & EDATE 3
How do I work with swedish excel 2003 that uses EDATUM 1
EDATE returns #NA Error when Excel opened again 6
Unable to Evaluate Formula 11
EDATE Function 4

Back
Top