If formula

[vmohan1978]

I want to update the status based on the formulas.

In Column B I have dates and In Column C next to date will be blank or YES.

In column "D" I want the output based on the following requirements.

example :

If C2 "YES" then output will be completed
C2 is blank and assume today is 13/2/2018 and date in B1 is 22/2/2018 If today is lessthan B1 then want the output to be "On track" or "Delay".

 

[AliGW]

Please clarify what you require if C2 is "Yes" - what do you mean by "output will be completed"?

=IF(AND(C2="",TODAY()<B1),"On Track","Delay")

 

[vmohan1978]

Aligw,

I am preparing the performance review status. If the performance review is completed on the mentioned date B1 then in C1 will reflect Completed.

Find attached the file hope it will give more clarity.

 

[AliGW]

In D4 copied down:

=IF(C4="Yes","Completed",IF(C$1<A4,"On Track","Delay in Process"))

 

[vmohan1978]

Thank you AliGW, formula working perfectly. Thank you very much for your time .

 

[AliGW]

No problem - glad to have helped.