Date functions is not working in Excel. How to proceed?

S

S Khadanga

In my computer, Microsoft excel date and time functions are not working. When
I am using the date functions I am getting result #NAME?. Can some one
advise me how to resolve the problem.
 
P

Peo Sjoblom

Which date function? If you are using things like EDATE then you need to
make sure the ATP (Analysis ToolPak) is installed and selected under
tools>add-ins, you might need the installation CD for this.

--


Regards,


Peo Sjoblom
 
M

myemail.an

Also, what format are the dates in?
Sometimes the unreliable piece of junk aka as Excel makes confusion
between the European and the American format: for example, when
reading the date '20/1/2007' it might not recognize it as European
format, and return an error because the calendar does not have 20
months.
 
P

Peo Sjoblom

True but that shouldn't return a name error as the OP

--


Regards,


Peo Sjoblom

Also, what format are the dates in?
Sometimes the unreliable piece of junk aka as Excel makes confusion
between the European and the American format: for example, when
reading the date '20/1/2007' it might not recognize it as European
format, and return an error because the calendar does not have 20
months.
 
Top