View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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