We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Length of Service formula does not calculate correctly

Accepted answer


We have issues with the formula to calculate incorrectly the length of service.

Content (required):

The following formula is calculating the Length of services however it does not return correct results on all records and we need to validate each record. I attach the screenshot of some incorrectly displayed results (First column is Enterprise Hire date and the 4th column is the calculated Length of service. I blurred the results that were shown correctly and opened the incorrect ones ). Any idea why this formula does not work properly and how we can fix it to have the constant and reliable results.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!