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
|