How to convert a date of birth to calculating age in Excel? The most common function you can use to calculate your age in Excel from your date of birth is YEARFRAC along with INT and TODAY. While calculating the age in Excel, how will you make the TODAY function static? While calculating the age in Excel, you have to make the TODAY function static. To do that, you just have to select the cell for which you want to convert the formulas to values, copy the cells and paste the values using the shortcut keys - ALT+ESV
確定！ 回上一頁
