N
nastech
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","")))
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","")))