Enable the DATEDIF function in Excel 2016

Solved
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

  • Votes
  • Date
  • Descending date
  1. 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!
    1. I have two columns of dates and I want the difference in years and days. Here is what the DATEDIFF function returns
    2. ```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!

      ```
    3. 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+
    4. @GyrusAnd it finally works. Thank you very much.