MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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) ?