Sep 11 2020 02:12 PM
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"))
Sep 11 2020 02:39 PM
thank you for your answer
One more question
can it be used in excel condittional formatting.?
how is the formula?
thank you
Sep 12 2020 03:15 AM
Discussion is duplicated here https://techcommunity.microsoft.com/t5/excel/questions-aboaut-excel-functions/m-p/1659537