DATEDIF(Start date, End date, Interval): calculating Time between Two Dates : DATEDIF « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. DATEDIF

Interval "d" means Days

Interval "m" means Months

Interval "y" means Years

Interval "yd" means If the two dates are in the same year

Interval "ym" means If the two dates are in the same year

Interval "md" means If the two dates are in the same month and year

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.