Need help for creating Sharepoint List Calculated Column

Regular Visitor

I'm a newbie and I have created a Sharepoint List basically to track tasks in a Sharepoint Online Site. I got 2 date columns named as "Due Date and Closed Date. Closed Date is populated once a user marks a task as completed, otherwise it's left blank. Trying to create a third calculated column named "Delay" that should return respective values when bellow conditions are met:

 

1. If Closed Date is equal or earlier than Due Date, value should be "In-time"

2. If Closed Date is later than Due Date, the value should be calculated as difference of number of days between Closed Date and Due Date (i.e. 3 Days).

3. If Closed Date is null/blank and today's date is equal or earlier than Due Date value should be "In-time". This value should be updated depending on when the user is accessing the list.

4. If Closed Date is null/blank and today's date is later than Due Date value should be calculated as difference of number of days between Due Date and today's date (i.e. 3 Days). This value should be updated depending on when the user is accessing the list.

 

Appreciate if anyone could help.

0 Replies