I NEED HELP QUICK

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

so im doing this project and i have been given a list of birthdays and i have
to find the peoples age. Im supposed to use the TODAY() function and i cant
figure out the formual. can someone please help!
thanks so much
 
First, see Chip Pearson's coverage of Excels undocumented (but very
functional) DATEDIF function:
http://www.cpearson.com/excel/datedif.htm

Then try this:

A1: (a birthdate)

this formula returns the age:
=DATEDIF(A1,TODAY(),"Y")

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Who wasn't paying attention in class?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Assuming that the birthdate is in column A row 1:

=(TODAY()-A1)/365.254

The (TODAY()-A1) gets the number of elapsed days from the persons date of
birth to the current date.

Dividing the number of days by the number of days in a year, plus a
fractional amount to account for leap years, gives you the age of the
individual (more or less)
 
Thank you so very much!! I just am not very good at all on figuring out this
stuff you have helped me so much! thank you again. Have a great day
 
Back
Top