converting a text date to actual date

[fasullo]

In Cell A1 I have the text: As of March 1, 2014
In cell A2 I need a formula that obtains the result: 3/1/2014

Looking for a simple formula.

Thanks

 

[iggydarsa]

When I type "March 1, 2014" in a cell, it automatically recognizes it as a date. Maybe you are using a text format, cant you change it to date format from "Format Cells"?
Or am i missing something here?

 

[fasullo]

When I type "March 1, 2014" in a cell, it automatically recognizes it as a date. Maybe you are using a text format, cant you change it to date format from "Format Cells"?
Or am i missing something here?

the text is "As of March 1, 2014"
w/o the quotation marks.

 

[Sahak]

Maybe this:

=TEXT(VALUE(A1),"m/d/yyyy")

 

[fasullo]

thanks for helping me think it through. figured it out.
=DATEVALUE(RIGHT(A3,13))

 

[vlady]

did you tried it with long month like December since you just have 13 characters.

=TEXT(VALUE(MID(A1,FIND("As of",A1)+5,20)),"m/d/yyyy")+0

EDIT:

or delete first 5 characters
=RIGHT(A1,LEN(A1)-6)

 

[fasullo]

that formula rocks ! thanks