Calculate years of service

[RickeyS]

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

 

[VoG]

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

 

[RickeyS]

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.