Forum Discussion
Wrong/different return of the weekday
Excel - German language
I have an older sheet, calculating the abbreviated weekday =Text(A1;"TTT").
The normal return was TWO letters, representing the workday, e.g. A1 = 2023-09-01 --> result Fr (for Friday).
But now, this formula returns THREE letters, in the example "Fri", for any reason.
Has anyone a explanation?
Within the options --> language ist set to German; all the formulas appear in German (no automatic change to English), and new formulas are also excepted in German language.
Andre990 Never noted this but perhaps you can use a work-around like:
=LINKS(TEXT(A1;"ttt");2)
