Date Question

[nastech]

Hi, Can't do yymmdd in a spread sheet ??? please give actual example,
=IF(ISERROR(Formula_To_Evaluate),ErrorValue,Formula_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.

 

[bob777]

If cell A1 contains this text

26/01/06 Robert

if(mid(A1,3,1)="/",do something,do something else)

will allow you to take action if your cell contains a date in front of
any text.

I assume you have other questions, if you are more specific I am sure
someone will help you.

The iserror function returns numbers for the different types of error.

hope this helps

 

[pinmaster]

It might help if you gave a few sample of your data, and explain what kind of
calculation you want do do and the result you expect.

Regards
JG

 

[nastech]

Hi, yes, sorry for long question, trying to fix at 3 in the morning..
hope I give the right items:

cell with general format, text date? in form of :yymmdd (is proceeded with a
colon so if format drops would not loose proceeding zero).
(yymmdd needed to quick view/enter dates, sorting / visual scan many
records..)

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

$H$7 has 5 for 5 days

=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",""))))

if use :060122 get correct dd response
if use :060130 get FALSE response, and rest of equation will not work.
if use : (no date) followed by text, get VALUE error


If I use the following equation:
=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",""))))

Rest of formula works, TODAY/DATE does not.

My best guesse I need to find an Exclusion that lets skip IF(AND(TODAY... so
it will not even look at it, items not to familiar with.. like text search:
if 1st 7 characters not equal :###### (colon 7 numbers, maybe a space)

I see the front part of my equation, as being incorrect: =IF(LEFT(T9,1)<>":",

Thanks in advance

 

[nastech]

correction update: formula works, within date works,
get FALSE if date in future of (5 days..); need to know how to make skip
false..

 

[nastech]

Formula Negation
How do I skip a formula, if left of cell does not equal a colon, followed by
7 numbers? thanks.

e.g.: date yymmdd
:060120

e.g.:
IF(LEFT(T9,7)= ??0000000),then do formula