How can I get an age using todays date and date of birth?

T

tjw1313

I'm using a spreadsheet where I need ages listed. Is there a formula that
can be used to compute the age if I use todays date and date of birth? So
far I am not having any luck. Thanks for any help you may provide. I am
using Excel 2000.
 
E

Eddie O

Actually, I don't think that last formula will work under certain
circumstances. You should check out the DATEDIF formula in excel help. For
the "end date" part of the formula, use TODAY() which will dynamically put
in today's date.
 

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

date of birth age formula 8
How do I calculate a person's age from date of birth and a date 4
date of birth or blank cell? 3
Calculating When Somebody Reaches a Certain Age 4
Calculating age from date of birth and ignoring if blank 3
what formula do i need to calculate a persons age 12
what is the formula to change date of birth into age 6
Using Year of Birth, from DOB, in later calculations 6

Top