Sharepoint Formula for days past Due Date

I need a formula to calculate the number of days past the Due Date in a SharePoint 2010 List.

I have successfully created the formula for calculating the number of days until the Due date:

=DATEDIF(TODAY(),[Due Date],"D"

But I need to be able to count the number of days that are past the Due Date.

Thank you
Lord_DragonAsked:
Who is Participating?
 
NorieVBA ExpertCommented:
Try this.

=IF([Due Date]<TODAY(), DATEDIF([Due Date], TODAY(), "D")&" past due date", DATEDIF(TODAY(),[Due Date],"D")&" until due date")
0
 
Lord_DragonAuthor Commented:
You're the man! Thanks

it also works this way..

=[Due Date]-TODAY()
0
 
NorieVBA ExpertCommented:
For some reason I though that wouldn't work in 'SharePoint', and that was why you were using DATEDIF.:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.