Forum Discussion
How to remove #NUM from DATEDIF negative formula
Hi, I have a quick query re DATEDIF. I am using the function to calculate the difference in years between each employee's start date, and the start of our annual leave calendar (Jan 1st 2022) to show...
=IFERROR(DATEDIF(A4,B4,"Y"),"start date greater end date")
or
=IFERROR(DATEDIF(A4,B4,"Y"),"")
Maybe with one of the above formulas, depending on the expected error response.
OliverScheurich Thank you! Appreciate it