Dates in A2:A91
Start Date in B2
End Date in C2
Message formula in D2
Min function for dates in E2
Max function for dates in F2

Formula in D2...
=IF(OR(B2< E2,B2F2,B2C2),"Start Date Error",IF(OR(C2<E2,C2F2,C2<B2),"End Date Error","OK"))
--
Jim Cone
Portland, Oregon USA



"Rodman"
wrote in message
Assume there is a date range from 1/1 to 3/31 (i.e., first quarter).
In cell A2 I have a start date, in cell B2 I have an end date.

If the start date is greater than the end date
or the end date is less than the start date
or the dates are not within the date range
display "Date Error" in cell C3

Can someone help with a macro or formula for this problem?
Thanks in Advance
--
Rodman Veney