Originally Posted by Fuzzycow23

Hello, I need help with a custom data validation formula for the following scenario:

Users can input an entry in any one of these formats (# for any number 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. Is this possible?