Multiple sharepoint list date column validation in list settings

Question

I am trying to add validation on multiple dates in SharePoint list.

Example: If end date is added by user the start date shall be mandatory. The start date shall not be greater than end date.

=IF(ISBLANK([End date]),TRUE,[End date]>=[Start date])

This is not working and not making start date mandatory.

Ganesh Sanap - MVP · Accepted Answer · 2023-02-20 09:18:14Z

Use below formula for your list validation settings:

=IF(ISBLANK([End date]),TRUE,AND(NOT(ISBLANK([Start date])),[End date]>=[Start date]))

You have to add this formula under List Validation settings.

Follow below steps:

Related threads:

Note:

Sometimes comma(,) does not work in formula (It is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

1 Answer 1