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