Use the DATEDIF function to calculate an age. : DATEDIF « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. DATEDIF
Input the formula: =DATEDIF(A1,TODAY(),"Y")
15.2.DATEDIF
15.2.1.DATEDIF(Start date, End date, Interval): calculating Time between Two Dates
15.2.2.Use the DATEDIF function to calculate an age.