I have a form to fill. In this form, I want validation in date. means the entry date will last 5 days. this will help to prevent entering an old date.
For example
if today’s date is 30/05/21
Then I want to enter the value between “25/05/2021” to “30/05/21”, means less then 5 days date they can possible to enter
This will work?
OR(([Date] ›Today()-5),( [Date]‹Today()+5))
Try it and find out.
User | Count |
---|---|
15 | |
11 | |
9 | |
8 | |
4 |