Pull Date from Cell

[Utradeshow]

Hi,

I have this formula I use to pull the date and time that they place in 1 cell from a customer quote sheet. It was working well until we got to a double digit month.....

The thing is they are inconsistant in stating the dates. such as "09/03 10AM" or "9/3 10AM" or even sometimes "9/03 10AM".

Can this formula be altered to accept variables

=TEXT(LEFT(INFO!A35,4),"MM/DD/YY")

 

[Smitty]

You could incorporate FIND to test the length:

FIND(" ",Info!A35)-1

HTH,

 

[Jonmo1]

Try

=TEXT(LEFT(INFO!A35,FIND(" ",INFO!A35)-1),"MM/DD/YY")

 

[CWatts]

You could also use
=DATEVALUE(LEFT(INFO!A35,FIND(" ",INFO!A35,1)))

Or you could set up data validation so that your users can only enter dates in the cell.

 

[Utradeshow]

Wow, Thank everyone, I will do some testing!!!!

 

[Scott Huish]

=LEFT(INFO!A35,FIND(" ",INFO!A35))+0
Format as MM/DD/YY