Formulas - Length of employment
Employee start date is 02 July 2014.
Still employed (do the date of exit is blank).
I need to show how long he has been with the company in years, months & days.
I have used the following formula to try and show how long an existing employee is with the company, as this is what what shown in the help menu:
(Date of Exit - Date of Joining) / (1000 * 60 * 60 * 24)
the column is showing the result as -16253.29 .
Could anyone assist or suggest what I need to do to fix this?