Check if date is in sequencial order in all sheets

[AriannaVV]

Hi all.
I have a workbook with 31 sheets. In each sheet I have a title like: Line 364 _ Central Park, Beach, Monday 01.08.2023. The format is dd.mm.yyyy. The date changes sequencial for each sheet. Let's say if the first sheet is ...Monday 01.08.2023 next sheet is Tuesday 02.08.2023. I need to check if the dates in all sheets are in sequencial order and there is no error in them (like different month for example "01.07.2023"). If there is an error the code should stop and a pop up message tell the sheet where the error is.

Can someone help please?

 

[AriannaVV]

=LET(r;DROP(REDUCE("";all_sheets;LAMBDA(a;b;VSTACK(a;INDIRECT("'"&b&"'!F3"))));1);s;--RIGHT(r;10);z;FILTER(s;ISNUMBER(s));SUM(--(z-VSTACK(TAKE(z;1)-1;DROP(z;-1))<>1))=0)

This formula is perfect!!! Exactly what I needed! Thank you so much for your time and effort. I did a lot of search but couldn't find anything similar. Another one precious solution!!

 

[JEC]

You're welcome! Cheers