Counting function

  • Thread starter Thread starter Mike P
  • Start date Start date
M

Mike P

Hey All

I need to figure out how to use the count function to
count a row of cells based upon a date range..Example..if
i need to count all of the line items in a spreadsheet
where the date is between say 8/8/2003 and 8/10/2003 how
do i do that? ALso how would i count all the cells that
occur before a certain date...like before 8/8/03?

PLEASE HELP ME
 
Mike,

for 1.

=COUNTIF(A2:Z2,">="&DATE(2003,08,08))-COUNTIF(A2:Z2,">"&DATE(2003,08,10))

for 2.

=COUNTIF(A2:Z2,"<"&DATE(2003,08,08))

adapt to fit your cell ranges
 
Back
Top