Date Formula (Results in last 7 days)

[phendrena]

Hi there,

I currently have the following formula :

=SUMPRODUCT(--('[Validation.xls]Sheet13'!H1:H3000=C3),--('[Validation.xls]Sheet13'!K1:K3000=H2))

I need to add into the above, a formula that will only display results in the last 7 days, the date range is in column 'K'. I have searched the forum as i know i've seen something before but wasn't able to find anything.

Please help.

Thanks,

[Bob Phillips]

Try

=SUMPRODUCT(--('[Validation.xls]Sheet13'!H1:H3000=C3),
--('[Validation.xls]Sheet13'!K1:K3000>=TODAY()-7),
--('[Validation.xls]Sheet13'!K1:K3000<TODAY()))