Hi,

I am working on a project in Sharepoint 2013 and within the list users will be creating/using there is an "Effective Date" Column. I only want to allow users to select certain dates. Is there an easier way to do this than column validation? or what's the best formula for column validation in this instance? 

I currently have the formula for the validation and it currently doesn't work: =OR([Effective Date]="9/21/2015",[Effective Date]="10/5/2015",[Effective Date]="10/19/2015",[Effective Date]="11/2/2015",[Effective Date]="11/16/0215",[Effective Date]="11/30/2015",[Effective Date]="12/14/2015",[Effective Date]="12/28/2015")

Thanks!

Hi

if these dates are fixed ( you want to insert in a validation column, why you don'tm set a column as a choice column - whithe these values?

I am hoping to make this a self-sustaining list so that once I am done with the project, minimal upkeep is needed and I can pass it onto someone in the project's department. 

Thanks for your idea! 

Hi LoSo7,

Here is the same post:

https://social.technet.microsoft.com/Forums/en-US/3beb244f-46d3-4749-8f8d-a1100514503c/sharepoint-2013-listcolumn-validation-for-a-dates?forum=sharepo&prof=required

Best Regards,

Lisa Chen