Counting dates on a condition

[LoveCandle]

Hi everyone,

I have a range of ten cells (B4:K4), some of these cells contains dates, and other cells contains text, what I want is counting number of cells that contain dates earlier than today's date.

I actually tried the following code, but it returns zero value

Please Login or Register  to view this content.

And when I tried the following formula, whcih shluld give as same result as VBA code, it returned an incorrect result:

Please Login or Register  to view this content.

Can you please help me finding a solution for this problem:

Thanks a lot,

[daddylonglegs]

Your syntax isn't quite right - try like this

=COUNTIF(B4:K4,"<"&TODAY())

[LoveCandle]

Thank you so much,