<div class="raw-html-embed"> The DATEDIF function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#datetime" onclick="onhyperlinkclick(this)">date and time functions</a>. It is used to return the difference between two date values (start date and end date), based on the interval (unit) specified.

 <h5 class="pt8">Syntax</h5>
 DATEDIF(start_date, end_date, unit)
 The DATEDIF function has the following arguments:
 <table style="width: 40%">
 <tbody>
 <tr>
 <th style="background-color: #f4f4f4" width="150ch">Argument</th>
 <th style="background-color: #f4f4f4">Description</th>
 </tr>
 <tr>
 <td>start_date</td>
 <td>The starting date of a period.</td>
 </tr>
 <tr>
 <td>end_date</td>
 <td>The ending date of a period.</td>
 </tr>
 <tr>
 <td>unit</td>
 <td>The specified interval. The possible values are listed in the table below.</td>
 </tr>
 </tbody>
 </table>
 The unit argument can be one of the following:
 <table style="width: 40%">
 <tbody>
 <tr>
 <th style="background-color: #f4f4f4">Unit</th>
 <th style="background-color: #f4f4f4">Interval Explanation</th>
 </tr>
 <tr>
 <td>Y</td>
 <td>The number of complete years.</td>
 </tr>
 <tr>
 <td>M</td>
 <td>The number of complete months.</td>
 </tr>
 <tr>
 <td>D</td>
 <td>The number of days.</td>
 </tr>
 <tr>
 <td>MD</td>
 <td>The difference between the days (months and years are ignored).</td>
 </tr>
 <tr>
 <td>YM</td>
 <td>The difference between the months (days and years are ignored).</td>
 </tr>
 <tr>
 <td>YD</td>
 <td>The difference between the days (years are ignored).</td>
 </tr>
 </tbody>
 </table>

 <h5 class="pt8">Notes</h5>
 If the start_date is greater than the end_date, the result will be #NUM!.
 <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the DATEDIF function.

 <h5 class="pt8">Examples</h5>
 There are three arguments: start-date = A1 = 3/16/2018; end-date = A2 = 9/16/2018; unit = "D". So the function returns the difference between two dates in days.
 <img alt="DATEDIF Function" src="https://static-helpcenter.teamlab.info/datedif_ad98f2afbb.png"></div>

DATEDIF Function

Docs

Argument	Description
*start_date*	The starting date of a period.
*end_date*	The ending date of a period.
*unit*	The specified interval. The possible values are listed in the table below.

Unit	Interval Explanation
Y	The number of complete years.
M	The number of complete months.
D	The number of days.
MD	The difference between the days (months and years are ignored).
YM	The difference between the months (days and years are ignored).
YD	The difference between the days (years are ignored).

DATEDIF Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud