date question

[dankar]

	original date	collection date
1	10/1/2016	10/8/2016
2	01/05/2017	01/07/2017
3	10/10/2018	10/17/2018
4	10/20/2018	10/30/2018

<tbody>
</tbody>

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.