Bonsour® Rick Rothstein (MVP - VB) avec ferveur ;o))) vous nous disiez :

Here is my offering (assumes "hire date" is in A1)...

=DATEDIF(TODAY(),DATE(YEAR(TODAY())+(DATE(YEAR(TOD AY()),MONTH(A1),DAY(A1))TODAY()),MONTH(A1),DAY(A1 )),"d")

May be this formula is shortest ??? :
=DATE( YEAR(TODAY()) + (DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))TODAY()) ,
MONTH(A1) , DAY(A1)) - TODAY()

HTH

--
@+
;o)))