Translation issue with NETWORKDAYS

**Sindhu Nair** · 06-13-2007, 01:59 PM

Hello folks,
I created a formula in a spreadsheet using the NETWORKDAYS function. It worked fine for users in the US, but when my coleague in Germany opened the spreadsheet, the formula returned the ?NAME error. On investigating, we discovered that the NETWORKDAYS function was not converted automatically to its German equivalent NETTOARBEITSTAGE. I believe that my colleague is also using an older version of Excel (not sure which). Has this problem been corrected in EXCEL 2003?
If this is still an issue with newer vesions of Excel, is there a workaround for this problem? At this time, we had to manually change my formula in my colleague's spreadsheet, but I would appreciate a quicker way of fixing this.
-Sindhu

**oldchippy** · 06-14-2007, 07:48 AM

To use NETWORKDAYS function your collegue needs to install the Analysis Tool Pak - has he?

http://office.microsoft.com/en-gb/ex...277241033.aspx

**arthurbr** · 06-14-2007, 08:24 AM

http://members.chello.nl/jvolk/keepitcool/download.html

**Sindhu Nair** · 06-14-2007, 09:36 AM

Thanks!
The problem was reported by another user in Brazil yesterday; used the translator to replace the function

The Analysis Tool Pak was installed for both the users, but it is surprising that it does not support multilingual translation
Regards,
Sindhu

**mfh** · 03-03-2009, 07:02 AM

Dear Sindhu,

I run into the same problem you had. NETWORKDAYS does not translate automatically in other language versions of Excel.
You mentioned that you solved the problem by using the translator; can you please specify what you mean with that? Is that an Excel function?

Regards,
Michiel

**oldchippy** · 03-03-2009, 07:21 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Hi and welcome to the forum,

Please read the rules before posting your question, in reply check out arthurbr's link in the post above

**biabailo** · 08-18-2011, 03:09 PM

Guys I'm having the same issue for the NETWORKDAYS and also XIRR.
The add-in are installed and enabled.

I don't want to depend on locate an replace for this to work on multiple regional language settings because it is supoose to be a global application.
Does anyone know why excel does not translate these functions ????
is there another way out ???
Many thanks!