Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

DATEDIF(Start date, End date, Interval)

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