Days to next anniversary
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)))
|