Removing Negative/ False
 

How do I skip a formula, if left of cell does not equal a colon, followed by
6 numbers? Thanks.
e.g.: date yymmdd

=IF(LEFT(T9,1)=":", does not work

currently working on / need help with something like:
=IF(ISNUMBER(MID((T10,2,6)),
=IF(AND(LEFT(T10,1)=":",ISNUMBER(MID(T10,2,6))), not doing this right?

:yymmdd followed by word text... or:
:060122 text then written...

$H$7 has 5 for 5 days, I get correct response for
greater than & less than date & rest of formula works,
if no date is present, i get a FALSE, and rest of formula does not work.

=IF(LEFT(T9,1)=":",IF(AND(TODAY()DATE(MID(T9,2,2) +100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd",IF(BE9="T","dn",IF(BF9="T","up",IF(AK9 <"","ck","")))