excel - How do I extract the month number from a date and return the month name? -


i have table contains column of dates in following format: m/d/yyyy. below picture, shows dates in column c:

enter image description here

goal: know how create function in vba extracts month number dates in column c , return month name in column e, shown in picture below:

enter image description here

i can enter month names manually looking in column c, wondering if there function can task automatically.

yup, text() it:

=text(c2,"mmmm") 

enter image description here


Comments

Popular posts from this blog

php - Embed BBCode within itself not working -

three.js - how to load gltf in three JS -

sql server - T-SQL: Access DB objects in same schema without qualifying? -