Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How can I modify Excel List to get day names returned by TEXT(TODAY()) e.g. in other languages instead of English ?

share|improve this question

1 Answer 1

You would have to put in the LanguageID into the format string:

http://support.microsoft.com/kb/324097

Here you go:

=TEXT(TODAY(),"[$-407]DDDD")

this should result in

Donnerstag, Freitag, etc ...

And because I am alway unsure about english formulars, here is my original for german users:

=TEXT(HEUTE());"[$-409]TTTT")

this results in the current day in english instead of german language

share|improve this answer
    
Wow, works great. I didn't know it's possible. Thanks! –  kurp Sep 20 '12 at 8:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.