Excel Calculate the date difference from today from a cell of "7/6/2012 10:26:42"

Question

So I have a cell with 7/6/2012 10:26:42 inputted, I want to show the date difference from today in another cell.

I tried to extract 7/6/2012 with =LEFT(A1, Find(" ", A1, 1) -1) but turned out theres a value error.

The formula works when I make A1 '7/6/2012 10:26:42, however it is not ideal because I have to work with the whole column.

Answer 1

For the difference between A1 and Today's date you could enter: =ABS(TODAY()-A1)

which returns the (fractional) number of days between the dates.

You're likely getting a #VALUE! error in your formula because Excel treats dates as numbers.