FORMULAS

%3CLINGO-SUB%20id%3D%22lingo-sub-2157625%22%20slang%3D%22es-ES%22%3EFORMULAS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2157625%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20I'm%20trying%20to%20create%20a%20formula%20that%20subtracts%20two%20dates%20(column%20A%20and%20B)%20when%20column%20value%20A%20is%20greater%20than%20zero%20and%20the%20value%20of%20another%20cell%20D%20which%20is%20a%20date%20is%20less%20than%20the%20date%20in%20column%20B%2C%20is%20this%20possible%3F%20Thank%20you%20for%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%2Fattachments-key%2Ff214d11d-c648-44df-a39d-eea1ac9f6e8f%23%22%20target%3D%22_blank%22%3EHelp%20Formulas%20and%20Functions%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%20I%20am%20trying%20to%20create%20a%20formula%20to%20rest%20two%20dates%20in%20column%20A%20and%20B%2C%20just%20if%20value%20of%20column%20A%20is%20major%20than%200%20and%20value%20of%20date%20of%20another%20column%20C%20is%20minor%20than%20value%20of%20column%20B%2C%20thanks%20for%20the%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2157625%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hola, estoy tratando de crear una formula que reste dos fechas (columna A y B) cuando el valor de  columna A es mayor a cero y el valor de otra celda D que es una fecha es menor a la fecha de la columna B, es esto posible? Gracias por la ayuda  Formulas and Functions

 

Hello, I am trying to create a formula to rest two dates in column A and B, just if value of column A is major than 0 and value of date of another column C is minor than value of column B, thanks for the help 

1 Reply

Hi @IASH2020 

 

You may use below formula:

=IF(AND(A1>0,D1<B1),B1-A1,"Not Applicable")

A sample file is also attached for your reference.

 

Thanks

Tauqeer