The datedif function is used to calculate the time difference and can return the number of days, months or years between specified two dates. The syntax is "DATEDIF (start date, end date, return type)"; "start date" To be less than the "end date", the value of "return type" can be: "Y" represents the number of years, "M" represents the number of months, D" represents the number of days.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2003 version, Dell G3 computer.

Recommended: "Excel Tutorial"

DATEDIF returns the date between two dates The number of year/month/day intervals. The DATEDIF function is often used to calculate the difference between two dates. It includes return types such as D, M, Y, YD, YM, MD, etc.

Syntax

DATEDIF(start_date,end_date,unit)

Start_date is A date that represents the first date or starting date within the time period. (The starting date must be after 1900)

End_date is a date that represents the last date or the end of the time period Date.

Unit is the return type of the required information.

• "Y"The number of whole years within a period.
  

• "M"The number of whole months within a period.
  

• "D"The number of days within a period.

Note: The end date must be greater than the start date, otherwise the result will be #NUM

The DATEDIF function is a hidden function in Excel. It is not available in the help and insert formulas, so how to use this function?

Steps to use the DATEDIF function in excel

1. For example, calculate the month difference from 2013-1-2 to 2014-7-11.

The unit here is "m ”, enter in English.

Input formula =DATEDIF(A2,A1,"m")

2. When the unit is ym , ignore the year and day in the date.

Enter the formula =DATEDIF(A2,A1,"ym")

##3. When the unit is yd , ignore the year in the date.

Enter the formula =DATEDIF(A2,A1,"yd")

Compare step three and step two to understand.

4. For example, if the date of birth is known, calculate the age of the employee.

Enter the formula =DATEDIF(C2,TODAY(),"Y")

can also be used Formula =YEAR(TODAY())-YEAR(C2)

5. For example, if the joining time is known, calculate the employee’s length of service.

Enter the formula =DATEDIF(B2,TODAY(),"Y")

You can also use the formula =YEAR(TODAY())-YEAR(B2).

The above is the detailed content of How to use datedif function. For more information, please follow other related articles on the PHP Chinese website!