Forum Discussion

Alexandra420's avatar
Alexandra420
Copper Contributor
Jun 08, 2023
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...
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Jun 15, 2023

    Alexandra420,

     

    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.

ganeshsanap's avatar
ganeshsanap
MVP
Jun 15, 2023

Alexandra420,

 

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.

Alexandra420's avatar
Alexandra420
Copper Contributor
Jul 05, 2023

ganeshsanap 

 

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

 

Resources