Multiple data validation

I am creating a worksheet and want to add validation rules to prevent users from inputting incorrect data. I experimented with Custom Data Validation but unsuccessful.

These are the rules needed:

Column "Date of Work":
a. Entries must be only dates
b. Entry date can not be after selected month (so anything after 7/31/23 should not be allowed)
c. Entry can not be after Column "Date of Review" or Column "Date of Training"

Column "Date of Review":
a. Entries must be only dates
b. Entry date has to be same month as selected month (July).
c. Entry can not be before Column "Date of Work" or after Column "Date of Training"

Thanks for your help!

Hi HansDouwe,

"Date of Work" shouldn't before 1/1/2023.
Any of the columns can be filled in even if other or all other columns are blank. I know this adds to the complication to find a good solution.
I really need to prevent certain entries to be entered in order to control our data rather than just letting user of the error.

Originally Posted by 6StringJazzer

What is allowed for Date of Work when Date of Review or Date of Training is blank (or both)?

What is allowed for Date of Review if Date of Work or Date of Training is blank (or both)?

Hi 6stringjazzer - If they are blank then "Date of Work" would only allow if input is in the form of dates and prevent any entries (dates) that are after selected month (so anything after 7/31/23 will not be allowed).

Originally Posted by HansDouwe

Is there also a date that Date of Work should not be before? Excel also considers the number 1 as a date (1 is January 1, 1900 in Excel)?

Can the Date of Work be filled in if the Date of Review has not yet been filled in? Can the Date of Work be filled in if the Date of Training has not yet been filled in?

Can the Date of Review be filled in if Date of Work has not yet been filled in? Can the Date of Review be filled in if Date of Training has not yet been filled in?

Instead of giving error messages when entering, you could also choose to mark incorrectly filled in fields (for example in red) and instruct the Excel user to adjust them. Is that also an option?

Hi HansDouwe,

"Date of Work" shouldn't before 1/1/2023.
Any of the columns can be filled in even if other or all other columns are blank. I know this adds to the complication to find a good solution.
I really need to prevent certain entries to be entered in order to control our data rather than just letting user of the error.

Originally Posted by 6StringJazzer

So in short, any missing values have no effect on validation.

That is correct