Find the Out of Sequence Date

[gr8whthunter76]

I've gotten pretty good with Excel thanks to you all, but I can't figure this one out in the image. I'm looking to find the month out of sequence. In the example I have Nov 2006, Dec 2006, Jan 2007 and then it jumps to Jul 2008, Aug 2008 and Sep 2008. What I am trying to do is extract the first cell that begins the sequence and the last cell before the sequence changes. Ultimately something that in AA12 would beginning the sequence and then in AB12 have the last date in the sequence. Then in AA13 and AB 13 have the next dates in the sequence and so on. So it would query from Y12 to Y20 and see y12, y13 and y14 are all in sequence and y15 isn't so in aa12 it would be Nov 2006 and ab12 would be Jan 2007. Not sure if I have to combine the dates into one column either such as instead of y12 is Nov and z12 is 2006 maybe combine them in another cell and then sequence them. Not sure if this is possible or not.

Thanks as always!!!!!

 

[JamesCanale]

I'm not crazy about this - you can't start in row 1:

MrExcelPlayground11.xlsx
	A	B	C	D	E
2	NOV	2006	11/1/2006	11/1/2006	1/1/2007
3	DEC	2006	12/1/2006	7/1/2008	9/1/2008
4	JAN	2007	1/1/2007	9/1/2021	10/1/2021
5	JUL	2008	7/1/2008
6	AUG	2008	8/1/2008
7	SEP	2008	9/1/2008
8	SEP	2021	9/1/2021
9	OCT	2021	10/1/2021
Sheet18

Cell Formulas
Range	Formula
D2:D4	D2	=FILTER(C2:C9,C2:C9-C1:C8>35)
E2:E4	E2	=FILTER(C2:C9,INDEX((C2:C9-C1:C8),(MOD(SEQUENCE(ROWS((C2:C9-C1:C8))),ROWS((C2:C9-C1:C8)))+1),1)>35)
C2:C9	C2	=VALUE("1/"&A2&"/"&B2)
Dynamic array formulas.