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