Formulas - Length of employment

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?


      • Sticky Posts

      • Team Zoho People in your city!

        We are back with our next series of community events to meet you at your city! We are delighted to invite you to join us for a day of insightful sessions, interactions with other Zoho People users, and one-on-one sessions with our product experts. This

      • Come, join our HR Community!

        Hello everyone, We are delighted to invite you to join the HR Community, an exclusive forum for HR professionals around the world to collaborate, learn and grow together. In the HR community, you will be part of a tight-knit HR group, wherein you can,

      • Ask the experts: A 5-hour live Q and A session on Zoho People

        We are back with the 'Ask the experts' session of the month! Your platform to get instant answers to your questions on Zoho People is now open. Our team of experts is here, on a continuous 5-hour stretch, to answer and give expert solutions. What to ask? Your questions, doubts or any hiccup revolving Zoho People. If you do not have any questions, you can follow the post to add it to your knowledge.   Where to ask? Simply use the comments' space of this post to type in your questions.You can start

      • Ask the experts: A 5-hour live Q and A session on Zoho People

        The awaited 'Ask the experts' session of the month is here to give instant answers to your questions on Zoho People.  Our team of experts is here, on a continuous 5-hour stretch, to answer and give expert solutions.   What to ask? Your questions, doubts or any hiccup revolving Zoho People. If you do not have any questions, you can follow the post to add it to your knowledge.   Where to ask? Simply use the comments' space of this post to type in your questions. You can start posting your questions

      • Webinar: What HR should be doing during this pandemic

        These are testing times for organizations, especially for Human Resources. From the reallocation of resources to finding new ways to manage a remote workforce, there are so many things that HR should be focusing on right now. Now is when expert advice can help. Join us for a free webinar and hear it from one of the leading industry experts, Nick Holley, on what HR should be doing during this pandemic.  This will be a partially interactive session where Nick will answer your questions once every 10