count number occurring within specific date range

G

Guest

I need to count the number of sales that have occurred within a specific date
range.

I have a worksheet showing a list of house sales with the sale dates.

I have another worksheet showing a week beginning date and a week ending date.

I want to know how many sales occurred between the week beginning and week
ending date by using the week beginning and ending dates in the formula.

My countif formula works if I type the beginning and ending dates in the
formula but not if I link to the cells.

I am using Microsoft Excel 2003
 

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

Weekending Date w/Less Than 3 days Assoc. with Prior Month 7
Pop-up box 2
Populate worksheet with data that meets date range criteria 3
Time Sheet Summary 1
Weekly Time Sheet Summary 2
Weekly Time Sheet Consolidate 1
Sumproduct Question Working With Start and End Date Range 1
Formula for week ending 2

Top