Need help to extract date

[chelseaaa]

I want to extract the date part 2011-08-05 06:00:00 +0000 as 5-Aug-11

I used this formula =TEXT(DATE(LEFT($D2,4),MID($D2,6,2),MID($D2,9,2)),"DD-MM-YY") to extract it to 05-08-11 but I want it as 5-Aug-11.

Can someone help me?

 

[mikerickson]

try =TEXT(DATEVALUE(LEFT(D8,10)), "d-mmm-yyyy")

alternalty, you could put
=DATEVALUE(LEFT(D8,10)) in the cell and format the cell with the custom format "d-mmmm-yy" so that the cell holds an excel serial date, which is easier to work with than a string.

 

[T. Valko]

I want to extract the date part 2011-08-05 06:00:00 +0000 as 5-Aug-11

I used this formula =TEXT(DATE(LEFT($D2,4),MID($D2,6,2),MID($D2,9,2)),"DD-MM-YY") to extract it to 05-08-11 but I want it as 5-Aug-11.

Can someone help me?

This works for me...

=--LEFT(D2,10)

Format as Date

 

[chelseaaa]

Thank u all for helping. I appreciate it.

 

[T. Valko]

Thank u all for helping. I appreciate it.

You're welcome. We appreciate the feedback!