PDA

View Full Version : [SOLVED] Simple Date to Text Conversion



akers77
04-13-2015, 09:40 PM
Hi!

I need some help converting a date into a text. On the excel sheet attached, there are two columns. The first one is a standard date format, the second one is a pull of the month of that date in text format. I'd like to pull the month and the date (ie: January 2015). How can this be done?

Thanks for the help! :)

mancubus
04-14-2015, 02:01 AM
hi.

you can custom format the cells to display the dates in desired format: "mmmm yyyy"

or you can use a formula which will return a text, not a date value.


=TEXT(A4,"mmmm")&" "&YEAR(A4)

akers77
04-14-2015, 05:33 PM
Thanks!

mancubus
04-14-2015, 11:49 PM
you are welcome. thanks for the feedback and marking the thread as solved.