software

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 lt;1.. and no date, then true. date entered, in
or out of range = ok true / false. Thanks.

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
--
Gary''s Studentquot;nastechquot; wrote:

gt; Hi, not sure if a problem (application was closing till fixed trick on if:
gt; NOT(isnumber, then (isnumber.. ), have equation for entering text date in
gt; cell form as:
gt;
gt; :yymmdd
gt;
gt; formula is for conditional format if within x days, when put formula in
gt; external cell to edit, / verify I get #value errors, they seem to be because
gt; I do not have a date in the source cell. do I disregard error?
gt;
gt; I added an item to show: if lt;1.. and no date, then true. date entered, in
gt; or out of range = ok true / false. Thanks.

sorry, forgot to include the formula

=IF(OR(AN9=quot;quot;,AU9=quot;quot;,LEFT(U9,3)=quot;kquot;),quot;quot;,IF(AND(A N9lt;1,AU9lt;1),OR(LEFT(U9,2)=quot;:?quot;,NOT(ISNUMBER(ABS(MI D(U9,2,6)))),AND(ISNUMBER(ABS(MID(U9,2,6))),TODAY( )gt;DATE(MID(U9,2,2) 100,MID(U9,4,2),MID(U9,6,2)-(($I$7 1)*2)))),quot;quot;))

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

quot;nastechquot; wrote:

gt; Hi, not sure if a problem (application was closing till fixed trick on if:
gt; NOT(isnumber, then (isnumber.. ), have equation for entering text date in
gt; cell form as:
gt;
gt; :yymmdd
gt;
gt; formula is for conditional format if within x days, when put formula in
gt; external cell to edit, / verify I get #value errors, they seem to be because
gt; I do not have a date in the source cell. do I disregard error?
gt;
gt; I added an item to show: if lt;1.. and no date, then true. date entered, in
gt; or out of range = ok true / false. Thanks.