Timeline for Calculating Date Difference in SharePoint using column Condition
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 9, 2022 at 9:08 | comment | added | Ganesh Sanap - MVP | Please accept it as an Answer if it helped you in any way & it will help others with similar question in future to find the correct answer easily. | |
| Dec 9, 2022 at 9:07 | comment | added | Ganesh Sanap - MVP | Great, glad you found the solution! | |
| Dec 9, 2022 at 8:39 | comment | added | Elvie Bantug | Thank you. Was hitting error using ISBLANK statement. What i did is try below and it worked: =IF([Actual Completion ]=0,DATEDIF([Start Date],TODAY(),"D"),[Actual Completion ]-[Start Date]) | |
| Dec 6, 2022 at 2:42 | history | answered | Ganesh Sanap - MVP | CC BY-SA 4.0 |