Compare different dates and return as Pass or Fail

[Ftdsa]

Hi,
I have data in the form of “dates”. How do I compare these dates and return as Pass or Fail?
E.g.
A1 cell: 12/10/21
B1 cell: 14/10/21
C1 cell: 25/11/21
So if all dates (A1 to C1) have been completed, it should return as “Pass” otherwise “Fail”.
Thanks

 

[SanjayGMusafir]

Hi,
I have data in the form of “dates”. How do I compare these dates and return as Pass or Fail?
E.g.
A1 cell: 12/10/21
B1 cell: 14/10/21
C1 cell: 25/11/21
So if all dates (A1 to C1) have been completed, it should return as “Pass” otherwise “Fail”.
Thanks

Assuming row 2 i.e from A2 to C2 contain status Complete

in D2 put

=If(Countif(A2:C2,"Complete")=3,"Pass","Fail")

 

[Peter_SSs]

Duplicate to: Dates and c

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread since the later duplicate already had a marked solution.