| 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 :
|
9
|
=DATEDIF(C8,TODAY(),"ym")
| ||||
and the days :
|
7
|
=DATEDIF(C8,TODAY(),"md")
| ||||
You can put this all together in
one calculation, which creates a text version.
| ||||||
Age is 38 Years, 9
Months and 7 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 :
|
01-Jan-60
| |||||
Age is :
|
52.10
|
=(TODAY()-C23)/365.25
| ||||
How to calculate Age in Excel.
On Tuesday, February 7, 2012 | 8:36 PM
0 Comments