excel formula questions

%3CLINGO-SUB%20id%3D%22lingo-sub-1659387%22%20slang%3D%22en-US%22%3Eexcel%20formula%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1659387%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22question.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217851i2FD75A70EEA904E6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22question.JPG%22%20alt%3D%22question.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1659387%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1659421%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1659421%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F790840%22%20target%3D%22_blank%22%3E%40taroda385%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDuplicate%20question!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20formula%20in%20D3%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(C3%3D%22%22%3B%22%22%3BC3%2B14)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%20that%20in%20E3%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(C3%3D%22%22%3B%22%22%3BIF(TODAY()%26gt%3B%3DD3%3B%22Finish%20Quarantine%22%3B%22Quarantine%22))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1659423%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1659423%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3EThank%20You%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1659436%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1659436%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20your%20answer%3C%2FP%3E%3CP%3EOne%20more%20question%3C%2FP%3E%3CP%3Ecan%20it%20be%20used%20in%20excel%20condittional%20formatting.%3F%3C%2FP%3E%3CP%3Ehow%20is%20the%20formula%3F%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

question.JPG

4 Replies

@taroda385 

Duplicate question!

 

Change the formula in D3 to

 

=IF(C3="";"";C3+14)

 

and that in E3 to

 

=IF(C3="";"";IF(TODAY()>=D3;"Finish Quarantine";"Quarantine"))

@Hans VogelaarThank You

@Hans Vogelaar 

thank you for your answer

One more question

can it be used in excel condittional formatting.?

how is the formula?

thank you