Forum Discussion
Filip_Vandelacluze
Nov 09, 2022Copper Contributor
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 ...
Patrick2788
Nov 09, 2022Silver Contributor
Filip_Vandelacluze
Nov 10, 2022Copper Contributor
Patrick2788
Thank you very much for the solution. Have a fine day !