AVS4YOU >> AVS Document Editor >> DATEDIF Function

Powered by

AVS Document Editor
This page is available in EnglishFrançaisDeutschItalianoEspañol
AVS Document Editor
Download
AVS Document Editor
Current Version:  4.2.3.302
Release Date:  12/27/2016
File Size:
125.17 MB

DATEDIF Function

The DATEDIF function is one of the date and time functions. It is used to return the difference between two date values (start date and end date), based on the interval (unit) specified.

The DATEDIF function syntax is:

DATEDIF(start-date, end-date, unit)

where

start-date and end-date are two dates you wish to calculate the difference between.

unit is the specified interval that can be one of the following:

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).

To apply the DATEDIF function,

  1. select the cell where you wish to display the result,
  2. click the Insert Function Insert Function icon icon situated at the top toolbar,
    or right-click within a selected cell and select the Insert Function option from the menu,
    or click the Function icon icon situated at the formula bar,
  3. select the Date and time function group from the list,
  4. click the DATEDIF function,
  5. enter the required arguments separating them by commas,
  6. press the Enter button.

The result will be displayed in the selected cell.

DATEDIF Function

Download AVS Document Editor Current Version:  4.2.3.302File Size: 125.17 MB

Please note that AVS4YOU programs do not allow you to copy protected material. You may use this software in copying material in which you own the copyright or have obtained permission to copy from the copyright owner.

AVS4YOU is a registered trademark of Online Media Technologies, Ltd., UK. Intel and Core 2 Duo are registered trademarks of Intel Corporation. AMD and Athlon X2 are registered trademarks of Advanced Micro Devices, Inc. Windows 10/8.1/8/7/XP/2003/Vista are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners.