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

**URL:** <https://forumautomation.com/t/microsoft-excel-tips-calculate-age-based-on-their-birthday-and-today-date/358>\
**Category:** Microsoft Excel Tips\
**Created:** [March 25, 2015, 4:40am UTC](https://forumautomation.com/t/microsoft-excel-tips-calculate-age-based-on-their-birthday-and-today-date/358 "2015-03-25T04:40:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![denizen](https://forumautomation.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@denizen](https://forumautomation.com/u/denizen)\
**Post date:** [March 25, 2015, 4:40am UTC](https://forumautomation.com/t/microsoft-excel-tips-calculate-age-based-on-their-birthday-and-today-date/358/1 "2015-03-25T04:40:17Z")

</div>

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

```