Question: how to calculate age from date of birth in years months and days?
Answer: To get the number of years: =DATEDIF(B2, TODAY(), "Y") To get the number of months: =DATEDIF(B2, TODAY(), "YM") To get the number of days: =DATEDIF(B2,TODAY(),"MD")