CountIf <Date

[Evolta]

Hey

Please Login or Register  to view this content.

I tried the code below and 1000+ variations. But I can't get it to work.
I am bounded to use .Value and not .Formula, so solutions in that scope will not do.

[6StringJazzer]

Try this:

Please Login or Register  to view this content.

I tested it and it worked for me. If it doesn't work for you then please attach your file.

[Evolta]

Date.xlsm

See above. If I can get the VBA script to work there, I should be able to change it slightly to make it work on my own file

[Evolta]

There are text and dates in my list (real workbook). (15 text + 11 dates)
4 of the dates are < today's date

Please Login or Register  to view this content.

So maybe I need something that first tells the countif to look at the dates properly?

[Evolta]

Please Login or Register  to view this content.

Kinda ugly, but this does work