Quote:
Originally Posted by 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 another cell.
Can anyone tell me how?
Thanks for the help
Sabine
|
Hi Sabine,
The formula below will extract the month and day from the text string, however you will not be able to use the result in calculations as it's not a true date format.
Still working on fixing that, but I'm sure someone more clued up on this than I will be along to improve this.
=MID(A1,FIND(":",A1)+1,FIND(",",A1)-FIND(":",A1)-1)
(the above formula presumes your text string is in cell A1, amend as necessary)