Count the number of dates less than a given date

M

mickblackburn2

I'm trying to count the number of dates with a range of dates that are iether
less than or greater than a give date (e.g. Today () function)
E.g. 10/08/09, 11/08/09, 12/08/09, 13/08/09. Today's date is the 12/08/09
the result would be 2 (10 & 11/08/09) less than the 12/08/09 and 1 (13/08/09)
greater than.

Is there a function to do this?
 
L

Luke M

Assuming your data is in column A
Less than today:
=COUNTIF(A:A,"<"&TODAY())

Greater than today:
=COUNTIF(A:A,">"&TODAY())
 

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

2 dimensional date sort 1
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.) 2
count on 3 criteria 3
countif with time 3
Question: How many occurences in date range? 4
Need help with formula to count the number of times each date appe 3
assign a number to the same date & start over with 1 on new date 3
Find LAST date when corresponing min value became available 7

Top