SOLVED

Adding a new column as month name

New Contributor

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

New Capture.JPG

1 Reply
best response confirmed by rameezpatel (New Contributor)
Solution

@rameezpatel 

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")