Convert date to text

D

Dave Peterson

=text(a1,"mmm")
or
=text(a1,"mmmm")
if A1 contains the date.

Or you could just give the cell a custom format of:
MMM
or
MMMM

The date will still be in the cell (in the formula bar), but you'll see the
month (or month abbreviation).
 
C

CLR

=LOOKUP((MID(A1,FIND("-",A1,1)+1,2)*1),{1,2,3,4,5,6,7,8,9,10,11,12},{"January","February","March","April","May","June","July","August","September","October","November","December"})

All on one line, watch out for word-wrap.

Vaya con Dios,
Chuck, CABGx3
 
M

Miguel

Hi Chuck,

Thanks for your help but give me an error. Should replace "," by ";" ?
Thanks

Miguel
 
B

Balzyone

did you try to use the cell formating to do this? If you need the date in
one field and to show May in another then you could have the date in one
cell, reference that from another cell and have the second one formated to
only show the MAY. You might have to change the way you put the date in
since the format of the date is generally recognized as the month first not
the day.
 
M

Miguel

Hi

If I use Format Cells I will have a problem with pivot tables . I need to
transform a date in a pure text .
Thanks
Miguel
 
C

CLR

Could be..........if you're using other than a U.S. version of
Excel...........give it a try.

Vaya con Dios,
Chuck, CABGx3
 
Top