Count the number of dates less than a given date

  • Thread starter Thread starter mickblackburn2
  • Start date Start 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?
 
Assuming your data is in column A
Less than today:
=COUNTIF(A:A,"<"&TODAY())

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