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...
I am using =DATEDIF(A1,TODAY(),"d") in the cell where the return is 9/6/1901 instead of the # of days
| 2022-07-21 | $21,500.00 | 9/6/1901 |
What am I doing wrong?
In addition, you may use
=TODAY()-A1applying General or Number format to the resulting cell