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?

Hi

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

Hi Danny,

Thanks for reply.

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

Regards,

Amien