How to calculate age in excel ?

To calculate age in Excel, you can use the DATEDIF function, which calculates the difference between two dates in years, months, or days. Here's the formula you can use: =DATEDIF(birthdate, TODAY(),"y") Replace "birthdate" with the cell reference of the cell that contains the birthdate, or you can enter the birthdate directly in the formula. Here's an example: