Display Months by looking at the dates

[hamad.fatima]

I have a column with dates like 01/01/07 , 02/15/07 etc.
Is there any way to create a formula in the next column to display
month like JAN-07 , FEB-07 etc.
I would really appreciate help.
Thanks

 

[JE McGimpsey]

One way:

A1: 01/01/07
B1: =A1

Format B1 as mmm-yy.

Or, if you want a text string (not an XL date):

B1: =TEXT(A1,"mmm-yy")

 

[Roger Govier]

Hi

With date in A1, in A2
=A1
Format>Cells>Number>Custom> mmm-yy
Copy down as far as required

Alternatively if you want a text value (instead of the value remaining
as a serial date number but formatted to show your desired result, then
use
=TEXT(A1,"mmm-yy")

 

[hamad.fatima]

Thanks you very much ,
It was a great help.

=TEXT(A1,"mmm-yy")
or
=A1 (format cell as mmm-yy)