3 dates per row, record when the 3 dates are in sequence

[Onebracketshort]

Have a worksheet with 3 date entries on each row corresponding to different events.

I’m looking to record the rows where the 3 dates follow in sequence in column f

For example, I'm looking to track these occurrences :

Column d: 02/10/2020

Column e: 02/11/2020

Column a: 02/12/2020

Sequence needs to be in the order above

Expected results below

Book1
	A	B	C	D	E	F
1	Main Date			Date 1	Date 2	Dates in Sequence
2	19/06/2019			15/06/2019	15/06/2019
3	18/06/2019			16/06/2019	17/06/2019	Sequence
4	19/06/2019			13/06/2019	19/06/2019
5	18/06/2019			13/06/2019	19/06/2019
6	17/06/2019			13/06/2019	18/06/2019
7	18/06/2019			16/06/2019	17/06/2019	Sequence
8	16/06/2019			16/06/2019	17/06/2019
9	16/06/2019			16/06/2019	16/06/2019
10	14/06/2019			12/06/2019	13/06/2019	Sequence
11	13/06/2019			13/06/2019	13/06/2019
Sheet1

thanks for looking

 

[mrshl9898]

=IF(AND(E2-1=D2,A2-1=E2),"Sequence","")

 

[Onebracketshort]

works perfectly, thanks a lot

 

[Onebracketshort]

@mrshl9898

Is there a way to reuse this function again and change it to record in the same way but for the below?

Column d: 02/10/2020 or 02/09/2020

Column e: 02/11/2020

Column a: 02/12/2020

So I’m looking for when column “ e” is one day behind column “a” and column “d” is either one or two days behind column “e”

thanks again

 

[Onebracketshort]

@mrshl9898

I have had a look at introducing an OR logical test. Would this do it?

=IF(AND(OR(E2-1=D2,E2-2=D2),A2-1=E2),"Sequence","")

cheers

 

[jasonb75]

I have had a look at introducing an OR logical test. Would this do it?

It looks good, does it give the correct answers when you enter it into your sheet?

 

[Onebracketshort]

It does give the correct answers. Just thinking I might have done it a better way

 

[jasonb75]

It's simple and effective, that means if it works then it's the best way.