lundi 10 juin 2019

Date Range Look up, Returned Value

I am searching a range of cells that contain dates. I want the formula to examine if any of the said dates are before a specified date. If the statement is true I want the formula to put yes in the cell, if false i want the formula to put no in the cell

=IF(COUNTIF('ESU1'!D3:D50,"

Based on the cells range there are dates before specified date but returning the fals results of "No"

Aucun commentaire:

Enregistrer un commentaire