Ask Your Question

Use month names in differrent languages

asked 2016-08-09 21:50:41 +0200

T4ng10r gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-08-09 22:25:05 +0200

erAck gravatar image
  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.
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-09 21:50:41 +0200

Seen: 344 times

Last updated: Aug 09 '16