Excel Use Date in IF Condition

Excel Use Date in IF Condition (worksheet solution) If you use a Text as a condition in IF, you can simply use double quote on the text such as "Text", but to use Date in IF condition, you cannot simply use double quote on a date. Lets recap how we apply condition on different data type. To apply condition on Number: =IF(A1>5,"large number","small number") To apply condition on Text: =IF(A1="John","My friend","Stranger") What about Date? Should we just use double quote as we ...