One of my columns contains dates. For the English locale dates can be formatted to show the day names. However, this option is lacking for the Netherlands locale. I tried using the function =TEXT(B1; "dddd") to convert dates to day names, but they are in English – even if the dates are formatted for the Netherlands locale. Is there any way to have the day names displayed in Dutch, other then by doing find&replace?
I'm using the English version of Excel for Mac 15.32.
Bookmarks