Read the post immediately below this one.

Biff

"Ducky" wrote in message
...
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