Forum Discussion
DATEDIF returning incorrect value
I'm using the excel function =DATEDIF(start_date,TODAY(),"Y") and for each line this function runs under, I'm getting the incorrect value. For example: I have an employee who's start date is 3/1...
Deleted If TODAY() is March 11, 2022 DATEDIF should return the correct 4 years. If, however, you entered the formula when TODAY() was March 10, 2022 you get 3, as DATEDIF returns the number of whole years. Microsoft warns that DATEDIF is not an official Excel function and that it can return incorrect results.
Riny_van_Eekelen Thank you, I'll keep that in mind when I use that formula.