Excel will update the Age cells based on the current date. To calculate the age, the DATEDIF function, set to check year, determines the number of years between the date in the DOB cell and the ...

There are a number of expressions that calculate age, but if precision matters, use the following: =YEARFRAC(dob,NOW()) where dob is the date of birth. Excel’s YEARFRAC() function calculates the ...