Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Here you go:


this should result in

Donnerstag, Freitag, etc ...

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


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


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.