I have a date column in a SharePoint list. This column need to be filled with dates that 2 years forward from today or more.
How can I write the validation formula for this?
Much appreciated if anyone can help.
Add a comment
|
1 Answer
Try something like below:
=[Date Column] > DATE(YEAR(Today())+2,MONTH(Today()),DAY(Today()))
Read more about column validations in SharePoint at:
answered May 7, 2020 at 3:32
-
-
Welcome. Please Upvote(^) and accept as an Answer as it helped you. Commented May 7, 2020 at 4:01