Skip to content
- 00:00 Intro to custom formulas in data validation part 2.
- 00:27 Greater than the current dayβs date.
- Formula example:Β
=B6>TODAY()
- 02:28 Date must be a weekday.
- Formula example:
Β =AND(WEEKDAY(B7) <> 7, WEEKDAY(B7) <> 1)
- 04:47 No more than 15 characters in the cell.
- Formula example:
Β =LEN(B8) <= 15
- 06:08 Must meet specific phone number parameters.
- Formula example:Β
=AND(LEN(B9) = 10, NOT(REGEXMATCH(TO_TEXT(B9),"D|s")))
- 10:14 Whole numbers between 1-20.
- Formula example:Β
=AND(ISNUMBER(B10),
NOT(REGEXMATCH(TO_TEXT(B10),""[.]"")),
B10>0,
B10<21)
Proudly powered by WordPress