Thread: Calculating Age
View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

You can use the DATEDIF function. E.g.,

=DATEDIF(birthdate,TODAY(),"y")

See www.cpearson.com/excel/datedif.htm for more information about
DATEDIF.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"devinm21" wrote in message
...
If I have a person's birthday, how can I calculate their
current age based on
today's date?


Thanks!