Need to automatically determine someone's duration in a spreadsheet? It’s a fairly straightforward process! Using the TODAY() function, you can subtract calculating age from dob in excel the date of birth from the current date to receive the answer in ages. Simply enter `=TODAY()-DOB` into a cell, where "DOB" is the cell displaying the person's b