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!)
You can put this all together in one calculation, which creates a text version.
Age is 54 Years, 4 Months and 11 Days
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"
If the age is 20.5, the .5 represents 6 months.
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!)
B
|
C
|
|||
8
|
Birth date :
|
1-Jan-60
|
||
10
|
Years lived :
|
54
|
=DATEDIF(C8,TODAY(),"y")
|
|
11
|
and the months :
|
6
|
=DATEDIF(C8,TODAY(),"ym")
|
|
12
|
and the days :
|
9
|
=DATEDIF(C8,TODAY(),"md")
|
|
You can put this all together in one calculation, which creates a text version.
Age is 54 Years, 4 Months and 11 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.
B
|
C
|
|||
23
|
Birth date :
|
1-Jan-60
|
||
25
|
Age is :
|
54.52
|
=(TODAY()-C23)/365.25
|
|
