What does error #AD? mean in Turkish Excel version?

A

Alexk

Hi,
The EOMonth(start_date,months) formula returns #AD? in a UK Excel version
created file when opened on Turkish Excel version. The EOMonth formula's
start_date reads from a separate cell where the date is manually entered.
Analysis ToolPak & Analysis ToolPak - VBA Add-ins are also selected.
The formula works on UK version Excel 2000, 2003. When the same formula is
tried on a blank spreadsheet on Turkish Excel version, it also works.
Has anyone come across a similar issue? Could anyone advise what the error
#AD? means and how to correct it?
Many thanks in advance!
 
B

Bob Phillips

Alex,

This is because the EOMonth function is part of the Analysis Toolpak, and
these functions don't automatically translate.

You will need to redo it with the Tuirkish equivalent, or change it to a
standard function

=DATE(YEAR(start_date),MONTH(start_date)+months+1,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
O

Ozgur Pars

Hi,
AD means NAME... could it be that you should be using ";" instead of ","
.... I not 100 % sure but when I changed my language settings from English to
Turkish all my formulas with a comma converted to a ";"...

My two cents,
Ozgur
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top