date question

[dankar]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]original date
[/TD]
[TD]collection date
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]10/1/2016
[/TD]
[TD]10/8/2016
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]01/05/2017
[/TD]
[TD]01/07/2017
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]10/10/2018
[/TD]
[TD]10/17/2018
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]10/20/2018
[/TD]
[TD]10/30/2018
[/TD]
[/TR]
</tbody>[/TABLE]
I have a list of 300 sample, i need to know the ones that were collected 7 days and more from the original sample

for example the answer here will be : 1,3 and 4

what would be the formula to get this result.

thank you

 

[Joe4]

If Original Date in column A and Collection Date in column B, and data starts in row 2, one way would be to add this formula to cell C2 and copy down for all rows:

=(B2-A2)>=7

You could then filter column C to only show the TRUE results.

 

[dankar]

If Original Date in column A and Collection Date in column B, and data starts in row 2, one way would be to add this formula to cell C2 and copy down for all rows:

=(B2-A2)>=7

You could then filter column C to only show the TRUE results.

Thank you so much

 

[Joe4]

You are welcome.