F
Fuzzycow23
Hello, I need help with a custom data validation formula for th
following scenario:
Users can input an entry in any one of these formats (# for any numbe
0-9):
1) ##/##'
2) ###/###'
3) ##/###'
4) ###/##'
Here is the code I have that works for format 1 and 2.
=OR(AND(COUNT(MID(H1,ROW(INDIRECT("1:"&LEN(H1))),1)+0)=4,MID(H1,3,1)="/",MID(H1,6,1)="'"),AND(COUNT(MID(H1,ROW(INDIRECT("1:"&LEN(H1))),1)+0)=6,MID(H1,4,1)="/",MID(H1,8,1)="'"))
Problem is, when I try to add more AND commands to include formats 3
and 4), excel does not allow it because it is too many characters. I
this possible
following scenario:
Users can input an entry in any one of these formats (# for any numbe
0-9):
1) ##/##'
2) ###/###'
3) ##/###'
4) ###/##'
Here is the code I have that works for format 1 and 2.
=OR(AND(COUNT(MID(H1,ROW(INDIRECT("1:"&LEN(H1))),1)+0)=4,MID(H1,3,1)="/",MID(H1,6,1)="'"),AND(COUNT(MID(H1,ROW(INDIRECT("1:"&LEN(H1))),1)+0)=6,MID(H1,4,1)="/",MID(H1,8,1)="'"))
Problem is, when I try to add more AND commands to include formats 3
and 4), excel does not allow it because it is too many characters. I
this possible