To calculate age in excel, enter date of birth in cell A2 and type =DATEDIF(A2,TODAY(),"Y") in B2. You'll get age in years.
確定! 回上一頁