The TODAY function returns todays date. Youll learn a few formulas for calculating age as a number of complete years, as well as getting actual ages in years, months, and days at todays date or a certain date. To see a person's age in years, months and days at the same time, use the DATEDIF Function combined with all arguments. Step 1: In E2, enter the formula =DATEDIF(C2,D2,"y")&" years "&DATEDIF(C2,D2 . document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); It denotes the end date. Repeatedly, we need to use the Fill Handle to find the age in the other cells. We will get the output shown above. Use DATEDIF to find the total years. Read More: How to Calculate Average Age in Excel (7 Easy Methods). "d" gets the days between dates. if ( dropdown.options[ dropdown.selectedIndex ].value > 0 ) { So, we can use the same DATEDIF formula again in our worksheet. The DATEDIF function needs 3 parameters. Calculate Days in Years 2.