Great - Thanks Guys


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =SUMPRODUCT(--($A$2:$A$100="Customer
> 1"),--($B$2:$B$100>TODAY()-14),--($B$2:$B$100<=TODAY()-7)
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Andibevan" <[email protected]> wrote in message
> news:O%[email protected]...
> > Hi All,
> >
> > I have data that is setup with Owners in Column A and Date Purchased in
> > Column B.
> >
> > What formula would I use to calculate the number of items that were
> > purchased by Customer 1 between 1 and 2 weeks ago?
> >
> > THanks
> >
> > Andi
> >
> >
>
>