Forum Discussion
taroda385
Sep 11, 2020Copper Contributor
excel formula questions
HansVogelaar
Sep 11, 2020MVP
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"))
- taroda385Sep 11, 2020Copper Contributor
thank you for your answer
One more question
can it be used in excel condittional formatting.?
how is the formula?
thank you
- SergeiBaklanSep 12, 2020Diamond Contributor
Discussion is duplicated here https://techcommunity.microsoft.com/t5/excel/questions-aboaut-excel-functions/m-p/1659537
- taroda385Sep 11, 2020Copper Contributor
HansVogelaarThank You