=SIFECHA

[ZULL-36]

Hola, estoy en un curso en linea de Excel, y estoy en los comandos y calculos de fechas. Pero al momento de querer poner el =SIFECHA, no la reconoce, mi version es la 2016, y deberia de reconocerla.

Alguien puede asesorarme por favor.

Gracias!

[#2]

@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.

[#3]

@ZULL-36 

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.