I have a datepicker. I went into list settings for the start date and set the validation to =Start Date >= today() That works great. Now I want the End Date to be within 2 years of that End Date or before 2021. How would I do that. I tried this =End Date < 2021. That didn't work. It prevented submission of the form. I've been looking but haven't found an answer.

Thanks for your assistance and have a great day!

2 Answers 2


This should do it:

=AND( [Start Date]>=TODAY(), [End Date]<DATE(2021,1,1), [End Date]<TODAY()+(365*2) )

Is dealing with an exact 2 years (leap year, etc.) important?


This will only allow people to use a date that is within 364 days of today.

=[End Date]<=TODAY()+364

Your Answer

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

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