I am using OOTB SharePoint Task List. Due Date column has date values tagged for each of the tasks. I am trying to add a calculated column which should be set to Valid if following two conditions are met:
- Task Status is not equal to completed.
- Due Date is greater than or equal to Today's date 'and' less than or equal to (Today's date + date after 15 days)
Otherwise it should be set to Invalid. Let's say today's date is 2/19/2019.
Due Date:2/21/2019, Task Status: 'Any Status value except Completed', this would set Cal Column Value: Valid
Due Date:3/10/2019, Task Status: 'Any Status value except Completed', this would set Cal Column Value: Invalid
Can someone help me with the formula, thanks in advance.