Validate date based on another date field

For example, I have a Leave Date and Return Date. How can I make sure that the Return Date is greater then Leave Date?


You can create a “Check” field with free text type and use IF() formulas to compare which date is greater.
Let’s say your Leave Date field locates in A2 and Return Date in A3. Then you may apply IF() as below in the “Check” field:


The formulas means when return date greater than leave date, returns Y in “Check” field. Otherwise, returns N.
Then, you can apply validation “Y” on the “Check” field:

With this configuration, you can only save the entry when the “Check” field is “Y.”