Checking a range of cells for False

Good morning,

Sorry I know I am having a brain fade on a very basic function, but for the life of me cannot think of it.

I have a list of dates in a column, and am wanting to compare them against today() in cell A1. If any of the dates are in the past, it returns a FALSE, if all of the dates are in the future, it returns a TRUE.

I know this is a really basic question .... can only put it down to Monday-itis after a big weekend

I feel like I am asking a rocket scientist how to light a match

If the dates are in column B, then you could put this in column C:

=B1>$A$1

...and just copy that down. You should get TRUE/FALSE answers as appropriate.

If you need to compare the entire range of dates to the date in A1 and only get TRUE if they are ALL in the future then use this array formula:

=AND(B1:B10>$A$1)

...confirmed by pressing CTRL-SHIFT-ENTER. You'll know the array is active when curly braces { } appear around your formula.

=COUNTIF(A2:A100,"<="&$A$1)=0

If Any of the cells in A2:A100 are less than or equal to A1 (Today()), then FALSE is Returned...

I like NBVC's suggestion...