excel formula questions

[taroda385]

[#2]

@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"))

[#3]

@Hans VogelaarThank You

[#4]

@Hans Vogelaar 

thank you for your answer

One more question

can it be used in excel condittional formatting.?

how is the formula?

thank you

[#5]

@taroda385 

Discussion is duplicated here https://techcommunity.microsoft.com/t5/excel/questions-aboaut-excel-functions/m-p/1659537