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

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


--


Regards,


Peo Sjoblom



"Jennifer" wrote in message
...
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)

"Jennifer" wrote in message
...
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

Who wasn't paying attention in class?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jennifer" wrote in message
...
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

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)
--
Kevin Backmann


"Jennifer" wrote:

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

Check out this link...

http://www.cpearson.com/excel/datedif.htm
--
HTH...

Jim Thomlinson


"Jennifer" wrote:

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

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

"Kevin B" wrote:

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)
--
Kevin Backmann


"Jennifer" wrote:

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