View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default I NEED HELP QUICK

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