Date shown as just month and year
 

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

Date shown as just month and year
 

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.


"Box666" wrote:

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

Date shown as just month and year
 

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

"Box666" wrote:

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