one way:
=DATEDIF(BD, TODAY(),"y")
See
http://cpearson.com/excel/datedif.htm
In article ,
"Lori" wrote:
I am trying to subtract the current date from the person birth date to get a
person age (in years not days). Is there a formula for this?
Thanks in advance
LB