CODEWITHSUNDEEP
excelvba
user3022875
user3022875

Reputation: 9018

How to convert text to date value

I have a 1/2/2015 21:00:00 in a cell A1 and when I do =istext(A1) I get TRUE and this makes it hard to compare this date to other dates because it is in the Text format. How can I convert this to a date format so I can compare it to other dates?

Thank you.

Upvotes: 0

Views: 52

Answers (1)

basodre
basodre

Reputation: 5770

Use the formula =DATEVALUE(A1).

This takes a text input and converts it to a date.

Upvotes: 1

Related Questions