Not Exactly...

In the sample being discussed if there was an error (i.e., the data not
within the range) an error would be displayed in cell C2. I would like to
put the error in the cell in which the error occurs. If, for example, the
date in cell A2 is not within the date range I would like to put the error
message #DER in that cell.

Additionally, I would like to make sure the start date is not greater than
the end date and the end date is not less than the start date (for that date
range). I think this will have to be a macro.

I have sucessfully used your example to make sure the dates are within thr
range but have not figured out how to determine the greater- than, less-than
date issue.

Regards,
--
Rodman Veney


"smartin" wrote:

You do see where to put "#DER" in the formula I gave, yes?

=IF(OR(A2<DATE(2009,1,1),A2DATE(2009,3,31),B2<DAT E(2009,1,1),B2DATE(2009,3,31)),"Rodman's
Message Here","No Date Error")

Or did you mean something different?


Rodman wrote:
Thanks! - This solution worked great!

now I have been asked to put the error message in the offending cell.

ex if cell A2 is outside of the date range the error message placed in cell
A2 coule be "#DER (for date error).

Thanks In Advance