Problem with calculated column (for date) as no. of days remaining for due date are not updated everyday.

I have a date column (named as Due Date) in my SharePoint 2013 list. Due date is saved in this "Due Date" column. I have created a calculated column with formaula "=Due Date-Today()" which shows me the no. of days remaining for Due Date.

However this is not updated everyday untill I edit this column from list settings.

I do not actully edit this column, I just open this calulated column from list settings and simply click on OK without making any actual changes.

Why this calculated column do not get updated on its own?

May 31st, 2015 4:34am


Have you created this column as per below steps

1.) Create a column with name "Today" of any type.

2.) Create a calculated column with formula "=[Due Date]-[Today]".

3.) Now delete "Today" column.

This calculates no. of days and updates automatically.

Hope it

Free Windows Admin Tool Kit Click here and download it now
May 31st, 2015 7:49am

Hi Danny,

Thanks for reply.

I will implement your solution now and will check the results by tommorow and let you know.



May 31st, 2015 8:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics