Forum Discussion
DATE IN SPANISH
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
... to change dates from English to Spanish, use this format in Format Cells>Number>Custom type: [$-1540A]dddd mmmm d;@.
This particular example gives you sábado junio 18 (you know than in Spanish, day and month names are not capitalized). Change/add the day/dates/month/year format as wanted; full details are in https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format or https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format.
- Thanks.
