Re: years of service formula. If you have a hire date in A2 then the total years and months service (as of today) can be calculated with this formula =DATEDIF(A2,TODAY(),y)& years &DATEDIF(A2,TODAY(),ym)& months.