Question: how to calculate age in excel with date of birth?
Answer: Y - returns the number of complete years between the start and end dates. M - returns the number of complete months between the dates. D - returns the number of days between the two dates. YM - returns months, ignoring days and years.