G
Guest
If I have a person's birthday, how can I calculate their current age based on
today's date?
Thanks!
today's date?
Thanks!
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
You can use the DATEDIF function. E.g.,
=DATEDIF(birthdate,TODAY(),"y")
See www.cpearson.com/excel/datedif.htm for more information about
DATEDIF.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
=DATEDIF(birthdate,TODAY(),"y")
See www.cpearson.com/excel/datedif.htm for more information about
DATEDIF.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
G
Guest
devinm21 said:If I have a person's birthday, how can I calculate their current age based on
today's date?
Thanks!
V
Vic Sowers
In whole years:
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))
R
Ron Rosenfeld
M
Mangesh Yadav
There's been a big discussion on this already.
http://excelforum.com/showthread.php?t=372455&highlight=bluenose
Mangesh
http://excelforum.com/showthread.php?t=372455&highlight=bluenose
Mangesh
G
Guest
My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?
M
Mangesh Yadav
Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1
Mangesh
format as number.
=A1-B1
Mangesh
G
Guest
It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
formating but it's not coming up correctly. Is there anything else I can do?
formating but it's not coming up correctly. Is there anything else I can do?
M
Mangesh Yadav
Could you post your data.
And the formula you are using.
Mangesh
And the formula you are using.
Mangesh
G
Guest
=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"
In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.
Thanks!
months, " & DATEDIF(I2,(H2),"md") & " days"
In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.
Thanks!
M
Mangesh Yadav
Ok. So you are looking for the YEARFRAC function.
=YEARFRAC(I2,H2)
which returns 31.5
Mangesh
=YEARFRAC(I2,H2)
which returns 31.5
Mangesh
M
Mangesh Yadav
Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.
Mangesh
function.
Mangesh
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.