=IF(AND(MONTH(A1)=MONTH(NOW()),DAY(A1)=DAY(NOW() )),YEAR(NOW())-YEAR(A1),YE
AR(NOW())-YEAR(A1)-1)

All on one line, watch out for email wordwrap..........

Vaya con Dios,
Chuck, CABGx3


"paralegal" wrote in message
...
is there an easy way to do this through a formula? I tried using the year
function and subtracting from current date but is doesn't caluculate
correctly if the birthday hasn't yet occured in current year. Thank you.