I have a field named "Due Date" and I am trying to add validation so users cannot enter a date more than 12 months from today (current date). This is SP2010.

I've tried this formula in the List / Validation Settings.

=[Due Date] < DATE(YEAR(Today()),MONTH(Today())+12,DAY(Today()))

I can't get it to work. I enter a due date which is greater than 12 months from now and it doesn't show me the user message. It allows me to enter the date.

What am I doing wrong?

1 Answer 1


Try using this:

=[Due Date] < DATE(YEAR(Today())+1,MONTH(Today()),DAY(Today()))


enter image description here

Note: Add this formula inside Column Validation under Column Settings.

  • Thanks your method works as we as my previous formula. I ended up finding that since I was using the formulas in the List Settings / Validation Settings it would not work. When I moved the formula from there to the Column Validation settings they worked.
    – gsr51
    Commented Jun 18, 2020 at 18:31
  • Great, glad it worked for you. Please Upvote and accept it as an answer as it helped you. Commented Jun 19, 2020 at 2:45
  • And Yes, I tried your formula and it was working for me as well. Commented Jun 19, 2020 at 2:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.