Change Excel day name to other languages

Question

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

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

Answer 2

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

Answer 3

=TEXT(WEEKDAY(A3),"[$-419]ddd")

List of language IDs: here

Nice formatting guide: here