Date Format

[Qaspec]

I have a column with the date formatted as 8/11/08 in one column. In the next
column over i would like to show just the month anth the year as Aug 08. The
issue is each time i type this into a cell it returns 8-Aug which acutally
equals 8/8/08. How can i show just a month and a year based on the date in
another column?

Example
COL_A COL_ B
8/12/08 Aug 08
9/1/08 Sep 08
9/17/08 Sep 08

 

[Peo Sjoblom]

Assume the dates start in A2

In B2 put

=TEXT(A2,"mmm yy")

or

=A2

and custom format as mmm yy


copy down



--


Regards,


Peo Sjoblom