EOMONTH to FIN.MES conversion

[ASASAS]

Any idea why (and more importantly how to fix it) when opening an excel
worksheet that has been created in Excel's spanish version with an english
version Excel, the program does not conver the FIN.MES formula to it's
equivalente in english (EOMONTH)? Does anyone know how to fix this?

Thanks

 

[Shane Devenshire]

Hi,

Don't know. But you could use Edit, Replace and enter FIN.MES in the Find
what box and EOMONTH in the Replace with box and choose Replace All.

A second possibility - is the Analysis ToolPak installed on the English
machine? Tools, Add-ins, Analysis ToolPak.

 

[Stefi]

Or you can substitute
=EOMONTH(TODAY(),0)
with
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)
Regards,
Stefi

„Shane Devenshire†ezt írta: