Ah, sorry.

Well you can't replace the cell values (A2 & B2) with an error message
(well you could with VBA, but I think this is overkill). What you can do
easily is apply conditional formatting to the problem cells,
highlighting error values when they occur.

This will be easiest if you have the date limits (e.g., 1/1/2009 and
3/31/2009) is cells somewhere. Let's assume they are in Y1 and Z1,
respectively.

In A2 you want to check three things: A2<Y1, A2Z1 or A2B2 should all
throw an error. In A2, the conditional format expression would look like

Formula is: =OR(A2<Y1,A2Z1,A2B2)

Make the conditional format something vivid, like bold red font against
yellow shading.

The conditional format expression in B2 would be quite similar.

Hope this helps!


Rodman wrote:
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,