if then based on date range
 

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.

if then based on date range
 

Something similar to this

=COUNTIF(A1:A15,"5/18/2008")-COUNTIF(A1:A15,"5/22/2008")
--
Best Regards,

Luke M


"Ann" wrote:

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.

if then based on date range
 

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?