|
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 :
|
43
|
=DATEDIF(C8,TODAY(),"y")
|
|
|
|
|
|
|
|
and the
months :
|
4
|
=DATEDIF(C8,TODAY(),"ym")
|
|
|
|
|
|
|
|
and the
days :
|
3
|
=DATEDIF(C8,TODAY(),"md")
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
You can
put this all together in one calculation, which creates a text version.
|
|
|
|
|
||||
|
Age is
43 Years, 4 Months and 3 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
:
|
56.67
|
=(TODAY()-C23)/365.25
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
No comments:
Post a Comment