Create Error message for different dates entered.

Hi All,

Let me start by using an example. I have a date (25-Aug-2010) in A1 and I want excel to display and error message when a date that lies in the weekend is entered into cell A2. Also an error message should be displayed when an earlier date is entered into cell A2. Anyone know how to do this?

Thanks for reading this Thread.

Use Custom Data Validation in cell A2 with this formula =AND(WEEKDAY(A2)<>1,WEEKDAY(A2)<>7,A2>A1)