View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default I NEED HELP QUICK

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