Perfect....The "COUNTIF" threw me off a bit, but it worked...Thanks.

"JE McGimpsey" wrote:

One way:

=IF(COUNTIF(A1:A5,"<=" & TODAY())0,"Be notified", "")


In article ,
"Brent" wrote:

I am trying to create an "IF" statement whose value is contingent upon a
range of cells. Basically, I have 5 cells with 5 different dates. I also
have a cell which is designated to search the 5 date cells ("IF" statement)
and if one of the cells has a date less than or equal to today's date...I
want my "IF" statement to notify me. Right now, I can only search one cell.
Any suggestions?