Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I am trying to prevent a date being entered into a cell if the date precedes the date in another cell.
To prevent entering a date in B2 that precedes the date in A2, apply the following Data Validation rule to B2:
Custom Formula = B2>=A2
In the options, select "reject input on invalid data".
Required, but never shown