is there a way to figure age using a formula like =todays date - birthdate, 10/11/2006 - 12/15/1970 to get age ?
2006-10-11 10:21:34 · 6 answers · asked by anneonceagain 2 in Computers & Internet ➔ Software
Put your birthdate in A1 and use this formula:
=DATEDIF(A1, NOW(),"y") & " years, " & DATEDIF(A1, NOW(),"ym") & " months, " & DATEDIF(A1, NOW(),"md") & " days"
And you will get a result like:
40 years, 10 months, 12 days
2006-10-14 10:53:30 · answer #1 · answered by O Caçador 6 · 1⤊ 0⤋
It's really just a regular formula (=sum 2006-1970).
2006-10-11 17:28:14 · answer #2 · answered by Stimpy 7 · 0⤊ 0⤋
this will do the trick, assume that the three lines below represent cells a1, a2, and a3:
=today()
27/08/78
=SUM(A1-A2)/365
the first cell returns today's date, the second is my date of birth, the third subtracts your birthday from today's date then divides it into years.
EDIT: but gandalf's formula below is alot less crude than mine lol
2006-10-11 17:34:25 · answer #3 · answered by piquet 7 · 0⤊ 0⤋
If you have cell A1 with the DOB, then paste this in any cell
=VALUE( TODAY() - E11)
Hope this help
Read my profile, I am the XLMan
2006-10-12 04:43:04 · answer #4 · answered by Anonymous · 0⤊ 1⤋
=(DATEDIF(A1,NOW(),"d"))/365.25
where cell A1 is your birthdate
EDIT: That is suppose to be 365.25. I dont know why it is showing 365.2... I guess I will need to ASK that question.
2006-10-11 17:34:49 · answer #5 · answered by gandalf 4 · 2⤊ 0⤋
=(NOW()-DATEVALUE("10/09/2006" ))/365.25
change format to display in number format, bot date format
2006-10-11 17:28:23 · answer #6 · answered by Anonymous · 0⤊ 0⤋