'Weekday from date in TEXT formula independent from used language in Excel [duplicate]
A | B |
----------------------|---------------|--------------------------
1 2022-02-14 | Mo | B1 = TEXT(A1,"DDD")
2 | |
3 | |
I have a date written in Cell A1 and I want to extract the weekday from it in Cell B1.
All this works fine as long as I use the English version of Excel.
Now, some co-workers use the German version of Excel.
When they open the file the DDD part of the formula is not recognized anymore.
Therefore, instead of the weekday in Cell B2 just DDD as text is displayed.
I think this problem is quite similar to the issue in this question.
Therefore, I already implemented the following formula to the name manager:
Time_Global_Day =INDEX(GET.WORKSPACE(37),21)
Afterwards I switched the formula in Cell B1 to:
=TEXT(A1,REPT(@Time_Global_Day,2))
With this solution I am able to extract the day as number from the date in Cell A1.
How do I need to modify it to display the weekday no matter which language is used for Excel?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
