I did post a similar question yesterday but it may have been too confusing
and I did not get an answer to suit my needs. I have decided to simplify my
question:
I have 3 columns (A, B and C), I need to add data validation to ensure dates
are entered with the following rules:
1. A2 cannot be greater than B2 or C2
2. B2 cannot be greater than C2 or less than A2
3. C2 cannot be less than A2 or B2
C2 can be an empty cell.
All dates must be = 01/01/2007
Thanks in advance.
Gareth