COUNTIF
 

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

COUNTIF
 

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

COUNTIF
 

If you have a column and want to count the number of entries whose date is
after today:

=COUNTIF(A:A,"" & TODAY())

so for:
1/14/2009
1/15/2009
1/16/2009
1/17/2009
1/18/2009
1/19/2009
1/20/2009
1/21/2009
1/22/2009
1/23/2009
1/24/2009
1/25/2009
1/26/2009
1/27/2009
1/28/2009
1/29/2009
1/30/2009
1/31/2009
2/1/2009
2/2/2009
2/3/2009
2/4/2009
2/5/2009
2/6/2009
2/7/2009
2/8/2009
2/9/2009
2/10/2009
2/11/2009
2/12/2009

the value 9 is displayed
--
Gary''s Student - gsnu200830


"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