CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Caselka
Caselka

Reputation: 1

Google Sheets formula for date detection

How would I create a custom formula in Google Sheets which would do the following:

If Column A, B, & C contains a date then change column X to YES

Upvotes: 0

Views: 48

Answers (1)

player0
player0

Reputation: 1

=ARRAYFORMULA(IF((IFERROR(DATEVALUE(A:A)))*
                 (IFERROR(DATEVALUE(B:B)))*
                 (IFERROR(DATEVALUE(C:C))), "YES", ))

Upvotes: 1

Related Questions