A.=MID(A1,7,4) B.=YEAR()-MID(A1,7,4) C.=YEAR(NOW())-MID(A1,7,4) D.=NOW()-MID(A1,7,4)
A.=COUNTIF(A :A ,A1)=1 B.=COUNTIF(A :A ,A1) C.COUNTIF(A :A ,A1)=1 D.=COUNT(A :A ,A1)=1
A.SUM(MOD(A1:A10,2)) B.{SUM(MOD(A1:A10,2))} C.{=SUM(MOD(A1:A10,2))} D.=SUM(MOD(A1:A10,2))