View original (French)

Enable the DATEDIF function in Excel 2016

Solved
Farouk -  
Farouk84 Posted messages 4 Status Membre -
Hi!
I want to use the DATEDIF function in Excel, but I don't know how to activate it in Excel.
Thanks a lot.

2 réponses

Réponse 1 / 2
Gyrus Posted messages 3360 Status Membre 526
 
Hello,

Although it is hidden and undocumented, the DATEDIF function is available in Excel 2016

Try it out, for example, with the formula: 
=DATEDIF(DATE(2016,8,1),DATE(2019,8,31),"Y")


See you!
17
Farouk84 Posted messages 4 Status Membre 5
 
I have two columns of dates and I want the difference in years and days. Here is what the DATEDIFF function returns
4
Farouk84 Posted messages 4 Status Membre 5
 
```html

It works, but in case I have data spread over several lines and I want to calculate. Column A=date1 and column B=date2 and I want in column C=DATEDIF in age? I want an automatic formula that takes everything into account. Thank you very much!

```
0
Gyrus Posted messages 3360 Status Membre 526
 
With the start date in A2 and the end date in B2, the age is given by the formula:
=DATEDIF(A2,B2,"y")&" years "&DATEDIF(A2,B2,"ym")&" months and "&DATEDIF(A2,B2,"md")&" days "

A+
0
Farouk84 Posted messages 4 Status Membre 5 > Gyrus Posted messages 3360 Status Membre
 
And it finally works. Thank you very much.
0