Forum Discussion

Filip_Vandelacluze's avatar
Filip_Vandelacluze
Copper Contributor
Nov 09, 2022

Date constant in a comparison

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 ...

Resources