To calculate age in Excel, you can use the DATEDIF function. Here's how you can do it:
excel=DATEDIF(birthdate, TODAY(), "Y")
Replace birthdate with the cell reference where the birthdate is stored. This formula calculates the difference between the birthdate and today's date in years.
For example, if the birthdate is in cell A1, the formula would be:
excel=DATEDIF(A1, TODAY(), "Y")
Make sure the birthdate is entered as a date format in Excel for accurate calculation.
