Nov 09 2022 09:44 AM
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?
Nov 09 2022 09:51 AM
Nov 09 2022 09:20 PM
@Patrick2788
Thank you very much for the solution. Have a fine day !