#Value Error?
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.
|