if then based on date range

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.
 
L

Luke M

Something similar to this

=COUNTIF(A1:A15,">5/18/2008")-COUNTIF(A1:A15,">5/22/2008")
 
A

Ann

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count date ranges 3
Number of dates falling in a date range 7
I want to count the total Number of dates between two dates How? 3
Help Please calculating date range - Other posts didn't help 6
date range within a date range 2
Array Function to Evaluate Dates 5
Counting number of rows between date range and meeting 2 string criteria 11
SUMPRODUCT Between Dates 7

Top