Date Formula
Posted by Scott Timberman on March 14, 2001 8:49 PM
i am trying to calculate someone's age using two dates.
example: 05/22/75 - 03/14/01 = 25 years old
how do i do it? what is the formula??
scott
Posted by Aladin Akyurek on March 14, 2001 10:00 PM
You can use either of
=YEAR(TODAY())-YEAR(A1) [ format the cell of the formula as general ]
=DATEDIF(A1,TODAY(),"Y") [ an undocumented function in Excel ]
=(TODAY()-A1)/365.25 [ format the cell of the formula as general ]
=DATEDIF(A1,TODAY(),"Y")&" years, "&DATEDIF(A1,TODAY(),"YM")&" months, "&DATEDIF(A1,TODAY(),"MD")&" days"
Use the last one to get the exact age.
Aladin
Posted by Dave Hawley on March 15, 2001 12:06 AM
:O)
Posted by Mark W. on March 15, 2001 9:24 AM
What does it mean when your nose grows?
Posted by Dave Hawley on March 15, 2001 10:50 AM
Don't understand the question. Please be direct!
Posted by Mark W. on March 15, 2001 11:16 AM
:O) vs :o) ?
