Jun 23 2020 02:09 AM
@ZULL-36 According to the Excel translator, SIFECHA is equivalent to the English DATEDIF. The Microsoft support pages write this about the function:
Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.
So it's been there for a long time and should be supported by E2016. But, what is it you are trying to achieve? Very likely you can do it without DATEDIF.
Jun 23 2020 02:26 AM
In addition to @Riny_van_Eekelen , if you start typing function name - yes, it is not recognized and Excel gives no prompt.
However, if you type entire function correctly it works
If open attached file formula shall be converted to your locale automatically.