Forum Discussion
Solved
Help with SharePoint calculations
Hi, I am using the below formula to calculate how many days a task is overdue, but do not want to show #NUM! when the due date has not been passed, and/or the due date is missing. With this I ge...
You are welcome. Glad to hear that it worked for you!
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
THANK YOU SO MUCH! This worked like a charm. 🙂
You are welcome. Glad to hear that it worked for you!
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Good morning ganeshsanap,
Now the formula doesn't calculate correctly. I used what you gave me:
=IF(OR(ISBLANK([Due date]),[Due date]=""),"0",IF([Due date]>TODAY(),-DATEDIF(TODAY(),[Due date],"d"),DATEDIF([Due date],TODAY(),"d")))
and the #of Days Overdue is not calculating the correct overdue days - see below screenshot:
Any ideas?
Thanks
Alex
