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