Add_months function problem
 

I have received an excel spreadsheet that has an unusual function i
several of the cells. An example follows:

Cell C17 reads: =add_months(C16,6,"NO_CHANGE","NYC")

When viewing this spreadsheet on an Excel 97 SR2 w/ Windows 95, th
result equals cell C16 (a date field) + 6 months (it seems to behave a
the author intended). When trying to view the same document on Exce
2K, XP, or 2003 running WinXP, the result is #NAME, and the error i
that it does not recognize the add_months function.

The Excel 97 machine does not have any user-defined functions fo
add_month, nor does it exist as a regular or add-in function. Ther
are no macros on the machine or on the document. Adding subsequen
cells at the end of the column using the same syntax on the Excel 9
machine also results in the #NAME error. I can find no special codin
for the individual cells that would allow for this function. Ca
anyone tell me how I can get the spreadsheet to behave properly on
machine with Excel 2k, XP, or 2003? Thanks

--
Message posted from http://www.ExcelForum.com

Add_months function problem
 

Hi
this add_month is (IMHO) a user defined function. It may reside in an
Add-in on your Excel 97 machine. So you may check the Add-in manager
This is not a Excel function!

--
Regards
Frank Kabel
Frankfurt, Germany

I have received an excel spreadsheet that has an unusual function in
several of the cells. An example follows:

Cell C17 reads: =add_months(C16,6,"NO_CHANGE","NYC")

When viewing this spreadsheet on an Excel 97 SR2 w/ Windows 95, the
result equals cell C16 (a date field) + 6 months (it seems to behave
as the author intended). When trying to view the same document on
Excel 2K, XP, or 2003 running WinXP, the result is #NAME, and the
error is that it does not recognize the add_months function.

The Excel 97 machine does not have any user-defined functions for
add_month, nor does it exist as a regular or add-in function. There
are no macros on the machine or on the document. Adding subsequent
cells at the end of the column using the same syntax on the Excel 97
machine also results in the #NAME error. I can find no special
coding
for the individual cells that would allow for this function. Can
anyone tell me how I can get the spreadsheet to behave properly on a
machine with Excel 2k, XP, or 2003? Thanks.


---
Message posted from http://www.ExcelForum.com/