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

Read the post immediately below this one.

Biff

"Ducky" <(E-Mail Removed)> wrote in message
news:3EE14FB4-9146-4722-882E-(E-Mail Removed)...
>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