Job Anniversary Days

 

Formulas

Years  : DATEDIF(A2,B2,"Y")

Months : DATEDIF(A2,B2,"YM")

Days   : DATEDIF(A2,B2,"MD")

Is Anniversary Today : 

    IF(AND((D2=0),(E2=0)),"Yes","No")

IS Anniversary In Next Week : 

    IF( AND((D2=11),(DATEDIF(A2,B2+7,"MD") >=0)),"Yes","No")