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