View original (French)

Enable the DATEDIF function in Excel 2016

Solved
Farouk -  
Farouk84 Posted messages 4 Status Member -
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 answers

  1.
    Gyrus Posted messages 3360 Status Member 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
    1. Farouk84 Posted messages 4 Status Member 5
       
      I have two columns of dates and I want the difference in years and days. Here is what the DATEDIFF function returns
      4
    2. Farouk84 Posted messages 4 Status Member 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
    3. Gyrus Posted messages 3360 Status Member 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
      1. Farouk84 Posted messages 4 Status Member 5 > Gyrus Posted messages 3360 Status Member
         
        And it finally works. Thank you very much.
        0