I want to apply validation setting so that my "ActionDate" should be always greater than 2 year and 6 month. I can able to set greater then today but how to set it should greater then 2 year and 6 months?


Try using this formula:

=OR([ActionDate] > DATE(YEAR(Today())+2,MONTH(Today())+6,DAY(Today())),ISBLANK([ActionDate]))

Validate Due Date less than 12 months

  • Try using this in column-validation, let me know if this works for you. Jun 24 '20 at 10:40
  • 1
    Thanks it works i changed according my requirement
    – kumar
    Jun 24 '20 at 10:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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