Microsoft Excel Tips - Calculate age based on their Birthday and Today date


#1

You can calculate a persons age based on their birthday and todays date.
The calculation uses the DATEDIF() function.

Birth date :	29-Apr-73					
						
Years lived :	41	 =DATEDIF(C8,TODAY(),"y")				
and the months :	10	 =DATEDIF(C8,TODAY(),"ym")				
and the days :	23	 =DATEDIF(C8,TODAY(),"md")				
						
You can put this all together in one calculation, which creates a text version.						
Age is 41 Years, 10 Months and 23 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 :	55.23	 =(TODAY()-C23)/365.25