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 Student


"nastech" wrote:

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.