Count Dates <Today?

K

Ken

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
 
D

Dave Peterson

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

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
 
F

FSt1

hi
assuming that you have real dates in your columns, try this
=countif(H2:DC7,"<"&Today())

Regards
FSt1
 
K

Ken

Dave ... (Hi)

Before posting I tried several variations ... I would have been there if
only I had remembered the "&" ...

Thank you & the many others that offer so many solutions on these boards ...
Kha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Dates & Return as % 2
Count Dates Help? 7
Count Dates between Dates exclude Text 3
Networkdays? 1
Index/Match (maybe?) 9
Dates & Text? 6
Conditional Format? 4
Formula ... Minus Holidays? 1

Top