Thanks:  0
Likes:  0

# Thread: Calculate years of service

1. ## Calculate years of service

This formula is supposed to calculate difference between today and date hired to give years and months of service. Works fine for all except if the person was hired in year 2000 then this formula shows 110 y. Any one know how to fix this? or have a different formula that works.

=DATEDIF(E21,TODAY(),"y")&" y "&DATEDIF(E21,TODAY(),"ym")&" m"

Thanks
Rick

2. ## Re: Calculate years of service

That formula works correctly for me. Are you sure that E21 isn't blank?

3. ## Re: Calculate years of service

Sorry,
Found problem, in E21 when looking at date it showed 01/03/00 but when you click on cell in formula bar it showed 01/03/1900. The person's hire date is 01/03/2000 so of course at a glance I thought formula was wrong but it was cell value wrong.

Thanks for looking.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•