COUNTIF

A

Al

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
 
J

Joel

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


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

Gary''s Student

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
 

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

Top