from
=COUNTIF(Results.xls!Excel_int,"="&"1/10/2008")-COUNTIF(Results.xls!Excel_int,""&"31/12/2009")


to
=COUNTIF(Results.xls!Excel_int,"="&"1/10/2008")-COUNTIF(Results.xls!Excel_int,""&Today())


"Al" wrote:

How can I count no. entries of the dates that are after 'TODAY's date

I already have
=COUNTIF(Results.xls!Excel_int,"="&"1/10/2008")-COUNTIF(Results.xls!Excel_int,""&"31/12/2009")
to show all entries within those dates but need to distinguish between past
and future 'bookings'

Thanks