AGE CALCULATION Formula
You can calculate a persons age based on their birthday and todays date.
You can calculate a persons age based on their birthday and todays date. |
||||||||||
The calculation
uses the DATEDIF() function.
|
||||||||||
The
DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.
|
||||||||||
(Makes
you wonder what else Microsoft forgot to tell us!)
|
||||||||||
Birth
date :
|
29-Apr-73
|
|||||||||
Years
lived :
|
38
|
=DATEDIF(C8,TODAY(),"y")
|
||||||||
and the
months :
|
4
|
=DATEDIF(C8,TODAY(),"ym")
|
||||||||
and the
days :
|
27
|
=DATEDIF(C8,TODAY(),"md")
|
||||||||
You can
put this all together in one calculation, which creates a text version.
|
||||||||||
Age is 38 Years, 4 Months and 27 Days
|
||||||||||
="Age is
"&DATEDIF(C8,TODAY(),"y")&" Years,
"&DATEDIF(C8,TODAY(),"ym")&" Months and
"&DATEDIF(C8,TODAY(),"md")&" Days"
|
||||||||||
Another
way to calculate age
|
||||||||||
This
method gives you an age which may potentially have decimal places
representing the months.
|
||||||||||
If the
age is 20.5, the .5 represents 6 months.
|
||||||||||
Birth
date :
|
1-Jan-60
|
|||||||||
Age is :
|
51.73
|
=(TODAY()-C23)/365.25
|
||||||||