|
|
Date & Time - Function DATEDIF
Page visited 12108 times
|
1. Make a difference between 2 dates, is not easier as a difference between 2 figures.
In the following example, you can notice that the result display a number and not a difference with day, month and year.
|
|
|
|
|
|
|
|
|
2. For instance, in the next example, the result of the difference between the month of the cells is wrong because there is 12 complete months or 0 from the last complete year.
|
|
|
|
|
|
|
|
|
3. So, to make a difference between 2 dates, you must use the following formula..
With date1 < date2
|
|
|
Formule de la cellule
=DATEDIF(date1;date2;parameter) |
|
|
|
|
|
|
|
|
4. The following spreadsheet shows the different writing for the parameter and the result expected
|
|
|
|
|
|
|
|
|
5. The opposite example, show you how powerful is to display several formulas with different parameters.
|
|
|
|
|
|
|
|
6. Try to solve the following example
|
|
|
|
|
|
|
|
|
|
