=SUMPRODUCT(--(A2:A500=TODAY()-7),--(B2:B500="poured slab"))

where A holds the dates and B text, if the text is part of a larger text
string use

=SUMPRODUCT(--(A2:A500=TODAY()-7),--(ISNUMBER(SEARCH("poured
slab",B2:B500))))


Regards,


Peo Sjoblom


"Janet BN" wrote:

Hi,
Can someone help me - I need to count the amount of instances of a text
value within a date range. I have date columns and text columns in a table
(the data is extracted from MS-Project).

eg. I am trying to count how many times "poured slab" happened in the past
week.

I have tried several things, no luck!