Errors in detecting end date of particular event in long data

[omaram]

I cannot detect the end date of particular last events in the attached file.
I use
(a) =AGGREGATE(15,6,$A$3:$A$28/($A$3:$A$28<>EDATE(N(+$A$2:$A$28),1)),ROWS(F$3:F3)) to fine start date and it work in all data range
(b)=IFERROR(AGGREGATE(14,6,$A$3:$A$28/($A$3:$A$28>$F3)/($A$3:$A$28<$F4),1),"") to find end date but in only works on single end date bu cannot find continuous end date of last event.

The data attached herewith make clear idea about the problem on "input-B" in column O (highilited there).

[GeoffW283]

This appears to be a follow-on from https://www.excelforum.com/excel-gen...end-event.html.

The col N:O formulas have not been correctly modified from the originals in col-F:G. In particular the range ends in the formulas need to be extended from 28 to 36 and 35 to 36. Lastly in I36 there needs to be a final date like 9/1/2009. Now you will get the expected 6/1/2009 date in cell O13.

In N3: copied down:
=AGGREGATE(15,6,$I$3:$I$36/($I$3:$I$36<>EDATE(N(+$I$2:$I$35),1)),ROWS(N$3:N3))
In =O3 copied down:
IFERROR(AGGREGATE(14,6,$I$3:$I$36/($I$3:$I$36>$N3)/($I$3:$I$36<$N4),1),"")