Date shown as just month and year

[Box666]

In column D I have a date in the standard format of 22/02/2008, in
column K i would like that date to be displayed as the month and
year. So in this case "Feb 2008"

I believe i can just add a simple formula that will lookup the date in
column D and display it as requested.

Could anybody assist please.

With thanks

Bob

 

[JasonP CCTM LV]

Would you be ok with Excel showing 08/31/08 as August-08 or as Aug-08?

If so, all you need to do is format Col K to show the date like that (Right
Click on the column, choose "Format Cells", Number, Date, then the format you
want. Then in K1 put "=D1" and copy that down.

 

[Sheeloo]

You can use the existing col itself
Just format it as Custom->mmm YYYY

or enter =D1 in Col K and format that Col as mmm YYYY