Use month names in different languages

[T4ng10r]

Hi,
I’ve created set of macros to calculate dates. Months names are in my national language.
Recently macros stopped working. Perhapse because I’ve changed language settings of my OS (Debian).
I would like to be able still to use =MONTH(“01-”&D2&"-2016") and in return receive like 8 (for August in my national language).
I would like to not NEED to change OS language to do so.

[erAck]

1. do not use locale dependent input such as specific date format or order; best use the DATE function instead, so =MONTH(DATE(2016,D2,1))
2. MONTH always returns the month number, locale independent; if you want a month name instead then format a date accordingly, e.g. =DATE(2016,D2,1) and apply number format MMM for short month name or MMMM for long month name.