Extract Date from text

[sabineb]

Hello
I have a cell that reads:

Week Ending:June 02, 2012

and I need to extract the date a June 02 (format 'mmm d') into anothe
cell.

Can anyone tell me how?

Thanks for the help
Sabin

 

[Ron Rosenfeld]

Hello
I have a cell that reads:

Week Ending:June 02, 2012

and I need to extract the date a June 02 (format 'mmm d') into another
cell.

Can anyone tell me how?

Thanks for the help
Sabine

To extract that number as a"real" date, where you can format the cell however you want:

=--TRIM(MID(A1,FIND(":",A1)+1,20))

To do the same, but return a text string (not a "real" date) of mmm d format, use:

=TEXT(--TRIM(MID(A1,FIND(":",A1)+1,20)),"mmm d")

 

[sabineb]

To extract that number as a"real" date, where you can format the cel
however you want:

=--TRIM(MID(A1,FIND(":",A1)+1,20))






Thanks so much this one did the trick

Sabin