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?

 

[Herakles]

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?

Can you please update your profile to include the Excel version you using and use XL2BB to submit an example of your data.

 

[AriannaVV]

Can you please update your profile to include the Excel version you using and use XL2BB to submit an example of your data.

 

[AriannaVV]

Can you please update your profile to include the Excel version you using and use XL2BB to submit an example of your data.

Hi! I use excel 365. I'm not sure if i'm correct with mini-sheet. I have this merged header in 31 sheets only date is changing. Thank you.

Βιβλίο1.xlsx
	E	F	G	H	I	J	K	L	M	N
1
2
3		LINE 365 - CENTRAL PARK, 3rd AVENUE, Saturday 07/07/2023
4
5
7

 

[Jaafar Tribak]

How about just setting up the workbook sheets manually in the correct sequential order and then just Protect the Structure of the workbook. That way, the sheets sequential order will always remain.

 

[AriannaVV]

How about just setting up the workbook sheets manually in the correct sequential order and then just Protect the Structure of the workbook. That way, the sheets sequential order will always remain.

This is not what I'm asking for. I always have the sheets in the right order. What I actually want is to check that the dates in the tittle are in sequential order, because I download the datasheet from a system database and sometimes I mistake the order of the dates. I hope I make it clear to you.

 

[JEC]

For example I named my first 3 sheets respectively 1,2 and 3
B3 returns if it is sequential. Assumed your text is in F3 on every sheet.

hulp tijden (3).xlsx
	B	C	D	E	F	G	H	I	J	K	L	M
2	Sequential?
3	TRUE				LINE 365 - CENTRAL PARK, 3rd AVENUE, Saturday 07-07-2023
4
5
1

Cell Formulas
Range	Formula
B3	B3	=LET(z,--RIGHT(VSTACK('1:3'!F3),10),MAX(z-VSTACK(TAKE(z,1)-1,DROP(z,-1)))=1)

 

[AriannaVV]

For example I named my first 3 sheets respectively 1,2 and 3
B3 returns if it is sequential. Assumed your text is in F3 on every sheet.

That would be nice if i had to do with only one workbook. But each month I deal with 250 workbooks in same logic that I create from scratch.I'll give it a try though. Thank you.

 

[Anonymous1378]

How about using a formula like this since your sheet order is always correct?

="LINE 365 - CENTRAL PARK, 3rd AVENUE, "&TEXT(DATE(2023,7,0)+SHEET(),"dddd dd/mm/yyyy")

 

[JEC]

It is coming from a database

because I download the datasheet from a system database