How to Convert DOB to Age in MS Excel. ... Every time you open the spreadsheet, Excel will update the Age cells based on the current date. To calculate the age, ...