How To Calculate Person's Age In Microsoft Excel 2010


F2 is the cell that contains the birthday of the person.

Use the following formula:
=TRIM(DATEDIF(F2,TODAY(),"y"))

Explanations:
DATEIF(cell with full birthday, today's date, interval)

The TRIM command gets rid of the day and month.



Once you have established the formula on the first cell, drag the lower right corner of the cell to spread the formula to other cells.  Enjoy!

Published: Dec 11, 2012

No comments:

Post a Comment

Sign up for the JBA Newsletter. A few times per year I may sell or give away gadgets and other electronics By signing up you ensure getting notified in a timely manner. I do NOT send you emails that will waste your time. Thank you.

Home

Hi. My name is Jesse, and I'm a technology enthusiast. I play with technology and share what I find on this blog. If you have any questions then please use the contact form below. I'll get back to you as soon as I can.


Contact

Name

Email *

Message *