How To Calculate Age On Excel 9 Steps With Pictures

You don’t need to use this for birthdays specifically. You can use any starting point, such as “Shipping Date,” “Purchased Date,” etc.

If the data is being auto-formatted as something else, highlight the cells and click the drop-down menu in the “Numbers” section of the Home tab. Select “Short Date” from the list of options.

=DATEDIF(B2,TODAY(),“Y”) =DATEDIF() is a function that calculates the difference between two dates. (B2,TODAY(),“Y”) tells DATEDIF to calculate the difference between the date in cell B2 (the first birthday listed) and the current date (TODAY()). It outputs the calculation in years (“Y”). If you’d rather see the age in days or months, use “D” or “M” instead.

=DATEDIF(B2,TODAY(),“Y”)&" Years, “&DATEDIF(B2,TODAY(),“YM”)&” Months, “&DATEDIF(B2,TODAY(),“MD”)&” Days"