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.