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

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.

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

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
toolsadd-ins, you might need the installation CD for this.

--


Regards,


Peo Sjoblom

"S Khadanga" wrote in message
...
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.

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

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.

On Aug 8, 4:31*pm, "Peo Sjoblom" wrote:
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
toolsadd-ins, you might need the installation CD for this.

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

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

--


Regards,


Peo Sjoblom

wrote in message
...
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.

On Aug 8, 4:31 pm, "Peo Sjoblom" wrote:
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
toolsadd-ins, you might need the installation CD for this.