Link to home
Start Free TrialLog in
Avatar of tru-numbers
tru-numbersFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Try this formula

=TEXT(MONTH(A1),"mmmm")
@n_swapnil, how does that work with different languages for the month names?
Avatar of tru-numbers

ASKER

I've requested that this question be deleted for the following reason:

Ne w assignment!
The question was answered. Whether or not the asker has a new assignment does not really matter.