• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

Display month name - International

Display the month name for a user supplied date in the language setting. EX
If US, Taiwan, etc.

US - October
Taiwan - Oktober
  • 3
1 Solution
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

you can build a lookup table with the language in the first row and the names of the months in the following 12 rows.

Then, in your data, you need a field that identifies the language you want to display. You can then use an Index/Match lookup formula along these lines:


see attached.

cheers, teylyn
Swapnil NirmalManager, Audit AnalyticsCommented:
Try this formula

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
@n_swapnil, how does that work with different languages for the month names?
tru-numbersAuthor Commented:
I've requested that this question be deleted for the following reason:

Ne w assignment!
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The question was answered. Whether or not the asker has a new assignment does not really matter.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now