• 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
0
tru-numbers
Asked:
tru-numbers
  • 3
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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:

=INDEX(Sheet2!$A$2:$B$13,MONTH(B2),MATCH(A2,Sheet2!$A$1:$B$1,0))

see attached.

cheers, teylyn
27866325.xlsx
0
 
Swapnil NirmalManager, Audit AnalyticsCommented:
Try this formula

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

Ne w assignment!
0
 
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.
0
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