MrExcel Publishing
Your One Stop for Excel Tips & Solutions

EDATE function

Posted by Brad Mauritzen on August 13, 2001 2:57 PM

Recently, tech support had to do some surgery on my computer, and nothing's been the same since. In excel, the 'EDATE' function no longer works. I'm getting the #NAME? error. I thought at first that I had an error in the formula that I typed, but if hit the 'fx' button on the toolbar to get the list of functions, EDATE isn't listed. Is this related to the version of excel? Any ideas on how to restore this function? Any help would be appreciated. Thanks.

Posted by Mark W. on August 13, 2001 3:01 PM

Re-add the Data Analysis ToolPak.

Posted by Brad M on August 13, 2001 3:22 PM

Thanks-that worked.