Quote Originally Posted by FDibbins View Post
This will do the same thing, but is a bit shorter...
=DATEVALUE(LEFT(D4,10))

The table idea is a good 1, and is probably the better way to go.

However, you you really want to just use your formulas, you could use this, copied wayyyy past where your data ends...
=IF(D5="","",DATEVALUE(LEFT(D5,10)))

If there is nothing in D, it wont show anything, when data is pasted into D, the formula will calc and show

So thanks to the above DATEVALUE here's what I was able to come up with, I decided to keep the time as well and now have a formula that will show both the date and time extracted from the cell.

=(DATEVALUE(LEFT(D1,10)))+(TIMEVALUE(MID(D1,12,5))) will return 11/14/14 13:37. Then I just double-click the corner and the formula applies all the way down. As long as the cell is set correctly when formatting (date> 3/14/01 13:30) it works flawlessly. Thanks again!