Change Excel day name to other languages

Solution 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

Solution 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