ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I work with swedish excel 2003 that uses EDATUM (https://www.excelbanter.com/excel-worksheet-functions/117045-how-do-i-work-swedish-excel-2003-uses-edatum.html)

DaveT

How do I work with swedish excel 2003 that uses EDATUM
 
I have to work with excel workbooks created in Swedish and English using the
analysis toolpak addin that has the same function called EDTUM in Swedish and
EDATE in english, using either version with the opposite spreadsheet causes
the NAME? error to appear. This is causing a problem because the workbooks
are constantly going between myself and my swedish counterparts

Niek Otten

How do I work with swedish excel 2003 that uses EDATUM
 
Hi Dave,

Try to avoid Analysis Toolpak; see

http://www.dicks-blog.com/archives/2...-addin-part-2/

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"DaveT" wrote in message ...
|I have to work with excel workbooks created in Swedish and English using the
| analysis toolpak addin that has the same function called EDTUM in Swedish and
| EDATE in english, using either version with the opposite spreadsheet causes
| the NAME? error to appear. This is causing a problem because the workbooks
| are constantly going between myself and my swedish counterparts




All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com