I want to find a person's age in Excel with A1 being their date of birth, A2, being TODAY. My current equation is =YEAR(A2)-YEAR(A1). This works, except that now it is a new year. If the person hasn't had a birthday yet this year, then they aren't technically that old yet. Is there a way to do this where the age of the person won't change until they have a birthday?
2007-01-04 02:18:19 · 4 answers · asked by Flutterfly25 1 in Computers & Internet ➔ Software
One option is the INT function.
=INT((A2-A1/365)
You'll get the number days different between the dates, and then the Int function will round down to the nearest integer.
2007-01-04 02:41:30 · answer #1 · answered by Javelinl 3 · 0⤊ 0⤋
Excell will automatically figure the number of days between dates, so try this: =(B1 - A1)/365
With B1 being =TODAY() and A1 being my birthday this returns 46.40 which is right...I will be 47 this year but am 46 right now. Reformat the cell to no decimal places to get rid of the .40 if you want
2007-01-04 02:38:30 · answer #2 · answered by rod 6 · 0⤊ 0⤋
you can by adding the month and day of that person using MONTH and DAY functions, like this:
=DATE( YEAR( TODAY() ), MONTH( A1), DAY( A1)) - A1
So it gets the year number from current date and gets the month and day numbers from his birthdate
If the above solutions are not good enough for you
Enjoy my profile, I am the VBAXLMan
2007-01-06 23:02:31 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Yes. Factor in the TODAY command.
See: http://www.exceltip.com/st/Working_Out_a_Person's_Age_in_Microsoft_Excel/634.html
2007-01-04 02:20:45 · answer #4 · answered by Mictlan_KISS 6 · 0⤊ 0⤋