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.
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
-
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!-
-
-
-
@GyrusAnd it finally works. Thank you very much.
-