Thread: #Value Error?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default #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.