Question: how to change a date of birth in excel?
Answer: Get the date of birth by using the DATE and DATEVALUE functions: DATE(B3,MONTH(DATEVALUE(C3&"1")),D3) Embed the above formula into DATEDIF to calculate age from date of birth in years, months, and days: