Counting Dates less then today

T

Teri

I have a column that I would like to have a count of all the dates that are
less then today's date.

I have tried: =countif(d2:d25,"<TODAY",0) This has only gotten me 0. If I
leave the " " out then I get an error message. What do I need to do?

Thanks in Advance.
 

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

Search closest day in the past from today 2
Conditional Formatting Less Than Today Week Days only 0
Using <= in countifs statement 1
Counting rows 4
SUM Q 2
Count the number of dates less than a given date 1
Show value from one cell in another cell if today falls between a date range 5
Excel 2010 countifs for date range 3

Top