A formula for birthdays
 

Is there a formula that allows you to put in a birthdate so it will
automatically update an age?

A formula for birthdays
 

The DATEDIF function can do this. For example,

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

The DATEDIF function isn't documented in the help file. See
http://www.cpearson.com/Excel/datedif.aspx for details.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


"Sadie Anne" <Sadie wrote in message
...
Is there a formula that allows you to put in a birthdate so it will
automatically update an age?