If Condition & loop Condition

[smarter]

Hello,

My Question is need to display a text value "Started" & "Completed"

cell a1 has start date

Cell B1 has End Date


display c1 "Started" or "Completed" based on the a1 and b1 dates..

a1 = 10th may (10-05-17)

b1= 20th may(20-05-17)

I have one more cell also , total number of days in d1 cell that also we can use in condition, )

(10 to 19 dates it will show started)

0n 20th and above(i.e: 21st may, 22nd may .....) it need to show "completed"

 

[Scott T]

Try

=IF(TODAY()>B1,"Completed",IF(TODAY()>=A1,"Started",""))

 

[smarter]

Thank you for your reply.. Scott

Its Working ... Great ..