Forum Discussion
Andre990
Sep 01, 2023Copper Contributor
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 ...
Riny_van_Eekelen
Sep 01, 2023Platinum Contributor
Andre990 Never noted this but perhaps you can use a work-around like:
=LINKS(TEXT(A1;"ttt");2)