From many different perspectives, calculating age is subtracting between two-time points. This current-age calculation formula also exists in Excel software through calculation functions. Specifically, the first time the formula (TODAY()-B2) will tell you the exact difference between the current date and the date of birth. Next, you need to divide the result you just found by 365 to get the final answer.