=SIFECHA

%3CLINGO-SUB%20id%3D%22lingo-sub-1482749%22%20slang%3D%22es-ES%22%3ESIFECHA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1482749%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20I'm%20in%20an%20Excel%20online%20course%2C%20and%20I'm%20in%20commands%20and%20date%20calculations.%20But%20when%20I%20wanted%20to%20put%20the%20'SIFECHA'%20doesn't%20recognize%20it%2C%20my%20version%20is%202016%2C%20and%20I%20should%20recognize%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomeone%20can%20advise%20me%2C%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1482749%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1483095%22%20slang%3D%22en-US%22%3ERe%3A%20%3DSIFECHA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F707423%22%20target%3D%22_blank%22%3E%40ZULL-36%3C%2FA%3E%26nbsp%3BAccording%20to%20the%20Excel%20translator%2C%20SIFECHA%20is%20equivalent%20to%20the%20English%20DATEDIF.%20The%20Microsoft%20support%20pages%20write%20this%20about%20the%20function%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3EWarning%3A%3C%2FSTRONG%3E%26nbsp%3BExcel%20provides%20the%20DATEDIF%20function%20in%20order%20to%20support%20older%20workbooks%20from%20Lotus%201-2-3.%20The%20DATEDIF%20function%20may%20calculate%20incorrect%20results%20under%20certain%20scenarios.%20Please%20see%20the%20known%20issues%20section%20of%20this%20article%20for%20further%20details.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3ESo%20it's%20been%20there%20for%20a%20long%20time%20and%20should%20be%20supported%20by%20E2016.%20But%2C%20what%20is%20it%20you%20are%20trying%20to%20achieve%3F%20Very%20likely%20you%20can%20do%20it%20without%20DATEDIF.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1483152%22%20slang%3D%22en-US%22%3ERe%3A%20%3DSIFECHA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F707423%22%20target%3D%22_blank%22%3E%40ZULL-36%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20addition%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20start%20typing%20function%20name%20-%20yes%2C%20it%20is%20not%20recognized%20and%20Excel%20gives%20no%20prompt.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20145px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200433i1A603D4A3A7EA83B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHowever%2C%20if%20you%20type%20entire%20function%20correctly%20it%20works%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20236px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200434iA0937A5A9579A65C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20open%20attached%20file%20formula%20shall%20be%20converted%20to%20your%20locale%20automatically.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

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

@ZULL-36 

In addition to @Riny_van_Eekelen , if you start typing function name - yes, it is not recognized and Excel gives no prompt.

image.png

However, if you type entire function correctly it works

image.png

If open attached file formula shall be converted to your locale automatically.