Data validation

[Ymmirx]

Hi Team,
I want to validate my inputs so no unnecessary data will be entered.
Please show me how.

1. Date
2. Rego# (eg:ABC123): 3x ALPHABET & 3x NUMERICALS
3. Time Out & Time In.

Date	Rego#	Driver Name	Type of Vehicle	Trip remarks	Load remarks	Destination	Time Out	Milage- Out	Time In	Milage- in
10-Oct-22​

 

[bebo021999]

Like this?

Book1
	A	B	C
1	Date	Rego#	Time
2	01/01/1950	ABC154	23:59
Sheet5

Cells with Data Validation
Cell	Allow	Criteria
A2	Date	between 01/01/1950 and 01/01/2050
B2	Custom	=AND(ISNUMBER(SEARCH(MID(B2,ROW($1:$6),1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789")),LEN(B2)=6)
C2	Time	between 00:00:01 and 23:59:59

 

[Ymmirx]

Like this?

Book1
	A	B	C
1	Date	Rego#	Time
2	01/01/1950	ABC154	23:59
Sheet5

Cells with Data Validation
Cell	Allow	Criteria
A2	Date	between 01/01/1950 and 01/01/2050
B2	Custom	=AND(ISNUMBER(SEARCH(MID(B2,ROW($1:$6),1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789")),LEN(B2)=6)
C2	Time	between 00:00:01 and 23:59:59

Thank you so much.

 

[Peter_SSs]

Thank you so much.

Are you sure that is what you want?
The column B validation will allow any combination of letters and numbers of 6 characters (eg "ABCDEF", "12b4a6") not only

3x ALPHABET & 3x NUMERICALS

Assuming the 3 letters must come first (& be upper case) followed by 3 digits, you could try this as your B2 validation formula.

=AND(LEN(B2)=6,FIND(MID(B2,SEQUENCE(3),1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),FIND(MID(B2,SEQUENCE(3,,4),1),"0123456789"))