13

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

16

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

  • Wow, works great. I didn't know it's possible. Thanks! – kurp Sep 20 '12 at 8:58
1

I changed below day names to my language and it works

=CHOOSE(WEEKDAY(B4),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

Source https://exceljet.net/formula/get-day-name-from-date

  • Nice Answer, could even go further with =CHOOSE(WEEKDAY(TODAY()),"Sun","Mon","Tue","Wed","Thu","Fri","Sat") – PeterH Jul 31 '18 at 12:58

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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