Forum Discussion
=SIFECHA
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 Replies
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.
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.
