Hi, Can't do yymmdd in a spread sheet ??? please give actual example,
=IF(ISERROR(Formula_To_Evaluate),ErrorValue,Formul a_To_Evaluate)
leaves so many questions, don't know where to start... every tick mark
missed = missed understanding.. "IF" included in (formula to to eval), front
and back? what is error value, type "error value"????? is error value
something it parrots back to you saying it isn't going to work?... got more

There has to be a way to skip equation, for no error for some condition,
just can't find that condition / equation prefix, e.g.:
IF(LEFT(T9,1)=":",... then perform equation, but if date out of range, get
false, but equation not letting me put:
IF(T9="","" has to be a simple way to skip equation

trying to use a general format cell that has text following a date, to read
date & perform a function on it, without errors.
So far have:

=IF(LEFT(T9,1)=":",IF(AND(MIN(AK109:AO9)<1,TODAY() DATE(MID(T9,2,2)+100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd"))

$H$7=5, and date 060220 gets false condition, havent been able to negate

for a cell that would have a date like:
:yymmdd (as in: 060220) followed by text

will perform the task, but does a false, if condition not met. (or VALUE
error if equation is changed), have other functions to add after this
equation, for more tasks to perform. All these errors, where's the
programmers.