if then based on date range

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

i have a column of dates. i'm trying to count how many in that column fall
within a particular date range.
for example, column A has 15 rows of dates.
i need the sum of which dates fall between 5/19 and 5/22 for example.
thanks.
 
ok, let me modify this.
a1: start date b1 5/19/08
a2: end date b2: 5/22/08

c3: 5/20/08
..
..
..
c55: 5/20/08

ok, based on the date ranges input for b1 and b2, whats the formula to look
in column C and count the days which fall between these dates?
 
Back
Top