Hi, thanks for the reply, been typing on this trying to make it work. Was
looking at ISNUMBER also (what to the dashes before --MID do?) either way,
could not get that to work. (original: IF(T9=":" is used with a date in
column, at least :999999, all works; not a good answer yet though). updated
info he

have 3 conditions:
1 < x days out, in-range (today & apply "dd")
2 x days out, then use sub formulas
3 cell empty, no date entered

currently working on / need help with something like:
=IF(LEFT(T9,1)=":", if date is :999999 all items work, no
date = FALSE error, status (1 & 2, not 3)
=IF(ISNUMBER(MID((T9,2,6)),
=IF(AND(LEFT(T9,1)=":",ISNUMBER(MID(T9,2,6))), not doing this right?
=IF(AND(LEFT(T9,1)=":",ISNUMBER(--MID(T9,2,6))), STATUS: (1 & 3, not 2)

details:
: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","ck")) ))

"Roger Govier" wrote:

Hi

Maybe
=IF(AND(LEFT(T9,7)=":",ISNUMBER(--MID(T9,2,6))),"do something","do
something else")

--
Regards Roger Govier