Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Command not recognized
I can use commands like IF, TODAY(), DATE(), SUM (along with others) without
any problem, but when I try to use EDATE, I get the error "#NAME". Can someone help me with this? Thanks |
#2
|
|||
|
|||
See EDATE help
EDATE See Also Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. "WLMPilot" wrote: I can use commands like IF, TODAY(), DATE(), SUM (along with others) without any problem, but when I try to use EDATE, I get the error "#NAME". Can someone help me with this? Thanks |
#3
|
|||
|
|||
Look in Tools Add-ins and verify that the Analysis Toolpak is checked
"WLMPilot" wrote in message ... : I can use commands like IF, TODAY(), DATE(), SUM (along with others) without : any problem, but when I try to use EDATE, I get the error "#NAME". Can : someone help me with this? : : Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format of "2005022011075" in Office 2000, is not recognized . | Excel Discussion (Misc queries) | |||
Data isn't being recognized. | Excel Worksheet Functions |