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 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)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

how to get value for date < 10 days in vba

Thread starter ganesh1988
Start date Mar 10, 2016
Tags

addition compare date loop

ganesh1988

New Member

Mar 10, 2016

Have a table as below

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Sample A[/TD]
[TD]Sample B[/TD]
[/TR]
[TR]
[TD]01 Mar[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]02 Mar[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]04 Mar[/TD]
[TD]10[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]10 Mar[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]11 Feb[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

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)