Hot answers tagged calculated-column
As Aron mentioned if you wanted it to automatically update you'll need to configure something to periodically update the values. Some options: 1) a SharePoint Timer Job that runs once a day to update the column 2) A Powershell script to update the column that runs once a day via the Windows Scheduler.
The problem is that calculated columns don't recalculate until an item is modified. So if nobody edits an item for 3 days after post-op, your calculated column will still show 0. You have 2 options within SharePoint: either show the op date and let your users calculate it in their heads, or create views that filter into 0-1 days post-op, 1-2 days post-op, ...
Only top voted, non community-wiki answers of a minimum length are eligible