=countif(h7:dc7,"<"&today())


Ken wrote:

Excel2003 ...

Range H7:DC7 contains DATES (m/dd), TEXT & EMPTY Cells.

I wish Formula to return number of Dates <Todays Date (exclude other TEXT &
EMPTY Cells)

Thanks to the many that support these boards ... Kha

--

Dave Peterson