Forum Discussion
Solved
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...
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")
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")