How to show the month of the referenced cell (containing a date)

D

Dave K

If a cell holds the date "2/1/08", what formula can I use that will
give me the following result:

"Feb - 08"

I tried =Month(a2)......but I just get the number of the month.

Thanks.
 
H

Harald Staff

=TEXT(A2,"mmm - yy")
Or simply
=A2
with the cell custom formatted mmm - yy

HTH. Best wishes Harald
 
Top