I have a sheet with 6 columns of dates (K to P). K is the job start date, P
is the job end date and the ones inbetween are inbetween dates. It is
possible for some of the ones inbetween not to need to have a date in them
(left blank).
What I want to do is validate the cells so that the user cannot enter
incorrect dates. For example, enter an end date which is before the start
date. I have managed to validate just start date against end date but when
it comes to a formula to include all the columns I get lost.
PS
The entry in the cell must be greater than 01/01/2007 and today