excel - How to convert text to date value -


i have 1/2/2015 21:00:00 in cell a1 , when =istext(a1) true , makes hard compare date other dates because in text format. how can convert date format can compare other dates?

thank you.

use formula =datevalue(a1).

this takes text input , converts date.


Comments