Forum Discussion
Adding a new column as month name
Hi
In this screen shot i highlighted date column, i want to add a new column on right side as "Month name" how can i add months name in my new column as it is defined in date column,
Example 1: 2nd row the date is "06/17/2013" so in my new column it appear as "June"
Example 2: 4th row the date is '10/18/2012" so in my new column it appear as "October".
this data contains more than 7000+ rows
Depends on goals.
1) You may reference =C2 and apply custom number format mmmm. Still will be a date, but shown as month name. Or you may apply this format to entire column C if concrete date is not needed.
2) If you need it as text, use =TEXT(C2, "mmmm")
1 Reply
Depends on goals.
1) You may reference =C2 and apply custom number format mmmm. Still will be a date, but shown as month name. Or you may apply this format to entire column C if concrete date is not needed.
2) If you need it as text, use =TEXT(C2, "mmmm")