#Value Error?

N

nastech

Hi, not sure if a problem (application was closing till fixed trick on if:
NOT(isnumber, then (isnumber.. ), have equation for entering text date in
cell form as:

:yymmdd

formula is for conditional format if within x days, when put formula in
external cell to edit, / verify I get #value errors, they seem to be because
I do not have a date in the source cell. do I disregard error?

I added an item to show: if <1.. and no date, then true. date entered, in
or out of range = ok true / false. Thanks.
 
G

Gary''s Student

Might be trying to do the numerical test on text. As an experiment try:

38749

in place of your date to see if the problem goes away
 
N

nastech

sorry, forgot to include the formula:)

=IF(OR(AN9="",AU9="",LEFT(U9,3)=":eek:k"),"",IF(AND(AN9<1,AU9<1),OR(LEFT(U9,2)=":?",NOT(ISNUMBER(ABS(MID(U9,2,6)))),AND(ISNUMBER(ABS(MID(U9,2,6))),TODAY()>DATE(MID(U9,2,2)+100,MID(U9,4,2),MID(U9,6,2)-(($I$7+1)*2)))),""))

and to ask how to correct if no date present portion not working:
not(isnumber..
thanks
 
Top