Creating Number of Days Until Due Column

Question

_{Monday, May 22, 2017 5:44 PM}

Hi I would like to create a days until due column in a SharePoint 2013 list. This needs to be a calculated column which calculates the Target Completion Date minus Today's Date. However, I am having issues figuring out how to include Today's Date information in order to run the calculation. 

Thank you for any assistance.

C

All replies (3)

_{Monday, May 22, 2017 6:10 PM}

Hi,

I hope the below information should help you:

https://social.technet.microsoft.com/Forums/en-US/401f729e-bd35-43b7-b6d6-ff765cd51859/creating-calculating-column-to-know-the-days-remaining-before-due-date?forum=sharepointadminprevious

https://social.technet.microsoft.com/Forums/en-US/9368bd9c-17fe-456d-a9ad-71a1ff6e6041/creating-a-column-to-count-days?forum=sharepointcustomizationlegacy

Cheers,
Maruthu
Please click the 'Mark as Answer' if this post solves your problem or "Vote As Helpful" if it was useful! :)

_{Monday, May 22, 2017 7:52 PM}

hi

use a scheduled powershell script wich will update your list each midnight.

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

_{Monday, June 5, 2017 2:44 AM}

Hi,

I am checking to see how things are going there on this issue. Please let us know if you would like further assistance.

Please click the "Mark as Answer" button if this post solves your problem or "Vote As helpful if it was helpful! :)