I have a SharePoint list where a person can add information. In one of the fields the user enters a date. We can call this field "Capture Date". I would like to add another field (we can call this "Days In Progress") that calculates the number of days that has passed since the capture date was entered. IE: "Current Date-Capture Date". I would this field to be dynamic.
The problem that I have is that the "Current Date" does not change everyday unless an item is edited. I did have a look on this website and a similar question was posted before. The url is: "http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_24086473.html
Is there a way that this can be done? I am open to any solution even Workflows or adding a refresh button somewhere that will update all items in the list to that I get a correct "Days in Progress".