Age Calculation
Age
Calculation
You
can calculate a person’s age based on their birthday and today’s date..
Microsoft
Excel Function
You
can calculate a person’s age based on their birthday and today’s 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-95
Years
lived : 22 =DATEDIF(C8,TODAY(),"y")
and
the months : 1
=DATEDIF(C8,TODAY(),"ym")
and
the days : 24 =DATEDIF(C8,TODAY(),"md")
You
can put this all together in one calculation, which creates a text version.
Age
is 22 Years, 1 Months and 24 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-90
Age
is : 27.47 =(TODAY()-C23)/365.25
Age Calculation
Reviewed by Rupesh
on
10:00
Rating:
No comments: