Date constant in a comparison

New Contributor

I need to test in Excel in a cell B1 if the date that is in a cell A1 is younger than 1/1/2018.

How do I type that? =IF(A1>#1-1-2018#;1;0)

Which delimiter should I use for the date? # ?

And may I note the date as 1-1-2018?

Possibly you know the solution?

2 Replies



You can write it as:





Thank you very much for the solution. Have a fine day !