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!
Bookmarks