what is the formula in excel to calculate age?
If you want to know the exact age, i.e. how many years, months and days there are between someone's birth date and the current date, write 3 different DATEDIF functions: To get the number of years: =DATEDIF(B2, TODAY(), "Y") To get the number of months: =DATEDIF(B2, TODAY(), "YM")