0

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?

=OR([ActionDate]>TODAY(),ISBLANK([ActionDate]))
| improve this question | |
1

Try using this formula:

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

Validate Due Date less than 12 months

| improve this answer | |
  • Try using this in column-validation, let me know if this works for you. – Ganesh Sanap Jun 24 at 10:40
  • 1
    Thanks it works i changed according my requirement – kumar Jun 24 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.