Age calculation

R

RobertLees

What formula should I use to calculate an age. =YEAR(TODAY())-YEAR(A1)
counts dates that haven't happened this year.
 
Top