how to get value for date < 10 days in vba

[ganesh1988]

Have a table as below

Date	Sample A	Sample B
01 Mar	1	2
02 Mar	5	6
04 Mar	10	20
10 Mar	1	1
11 Feb	1	1

<tbody>
</tbody>

When Date column has date < current date -7 days, need to Add Sample A and Sample B

So the output will be 2 (for the 11 feb column)