I would like my target completion column to have a date that is greater than in my start column. Excel supports a date validation option but I do not see this in Google Sheets.

Is it there and I just don't know how to use it or is my only option to write an Apps Script add-on?

marked as duplicate by Rubén, ale, jonsca Nov 12 '16 at 1:04

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

migrated from superuser.com Nov 10 '16 at 6:31

This question came from our site for computer enthusiasts and power users.

  • Please don't post the same question across sites on Stack Exchange. – Rubén Nov 11 '16 at 13:50

It is easy with a specific date but I think would require a script if to apply on a row by row basis (a moving target for the comparisons).

An alternative is to apply Conditional formatting... instead (to warn of but not prevent inappropriate entries).

Not the answer you're looking for? Browse other questions tagged or ask your own question.