Count the number of dates less than a given date
 

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?

Count the number of dates less than a given date
 

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

Greater than today:
=COUNTIF(A:A,""&TODAY())
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mickblackburn2" wrote:

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?