Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |