Read the post immediately below this one.
Biff
"Ducky" <[email protected]> wrote in message
news:[email protected]...
>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
Bookmarks