Command not recognized

[Guest]

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

 

[Guest]

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.

 

[Lady Layla]

Look in Tools Add-ins and verify that the Analysis Toolpak is checked


: 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