Counting Records That meet Multiple Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of dates in cells

1/5/200
5/1/200
2/4/200
4/5/200
2/5/200
3/30/200
6/23/200

I want to count the number of dates that are later that 2/1/2003 and earlier than 5/30/2003. How do I do this with a formula
 
=SUMPRODUCT(--(DateRange>Date1),--(DateRange<Date2))

where DateRange refers to the range housing your dates, Date1 to a cell
housing 2/1/2003, and Date2 to a cell housing 5/30/2003.

Julie said:
I have a list of dates in cells:

1/5/2003
5/1/2003
2/4/2003
4/5/2003
2/5/2003
3/30/2003
6/23/2003

I want to count the number of dates that are later that 2/1/2003 and
Click to expand...
earlier than 5/30/2003. How do I do this with a formula?
 
Back
Top