el formato de fecha se reconoce como texto y no lo puedo cambiar

%3CLINGO-SUB%20id%3D%22lingo-sub-1604559%22%20slang%3D%22es-ES%22%3Ethe%20date%20format%20is%20recognized%20as%20text%20and%20I%20can't%20change%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604559%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20worked%20a%20formula%20in%20excel%20365%2C%20when%20I%20opened%20it%20in%20Excel%202010%20did%20not%20recognize%20the%20SI%20function.%20SET%2C%20I%20changed%20it%20to%20a%20nested%20YES.%20Then%20when%20you%20try%20to%20subtract%20the%20date%20from%20a%20cell%20to%20the%20TODAY%20function%2C%20I%20get%20the%20error%20that%20cannot%20be%20subtracted.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606471%22%20slang%3D%22en-US%22%3ERe%3A%20el%20formato%20de%20fecha%20se%20reconoce%20como%20texto%20y%20no%20lo%20puedo%20cambiar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606471%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767334%22%20target%3D%22_blank%22%3E%40ingdiegogarcia%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20share%20the%20screenshot%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

trabajé una fórmula en excel 365, cuando la abrí en Excel 2010 no reconoció la función SI.CONJUNTO, lo cambié por un SI anidado. Luego al intentar restarle la fecha de una celda a la función HOY, me sale el error que no se puede realizar la resta. 

1 Reply

Hi @ingdiegogarcia,

 

Can you please share the screenshot 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more