I need a formula in Google Sheets that will return a "Y" or a "N" in column X if any of the values in columns O through W contain a date from 2019.
"Y"
"N"
X
O
W
date
2019
I have tried IF(O2:W2)="2019","Y","N".
IF(O2:W2)="2019","Y","N"
Aucun commentaire:
Enregistrer un commentaire