A formula for birthdays

  • Thread starter Thread starter Sadie Anne
  • Start date Start date
S

Sadie Anne

Is there a formula that allows you to put in a birthdate so it will
automatically update an age?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Birthdays database 2
Count cells containing text, multiple criteria 2
Reference Separate Sheet for Formula 2
Happy Birthday Formula Flag Needed 12
Birth date from age 2
Calculate birth date from age 4
Happy Birthday Floppybootstomp 15
Happy Birthday Muckshifter 6

Back
Top