Forum Discussion
Solved
DATE IN SPANISH
In my new laptop, using the same excel and the same template, the funtion TEXTO(A6,"ddd dd mmm") returns the name of the day in english ("Sunday", etc) and I need it in spanish ("Domingo", etc). E...
Hi Ruben,
Perhaps that's due to your Windows settings, but in any case you may add locale identifier to the formula like
=PROPER(TEXT(A6,"[$-es-es]ddd dd mmm"))
More is here https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format
Works but without "proper"
Thank you very much
Ruben, you are welcome.
In some cases formula returns only lowcase text like "wed 10 oct". PROPER is to shift first letters to uppercase, like "Wed 10 Oct". You may check here https://en.excel-translator.de/translator/ how formula looks in Spanish