Does this work for you?
“=NOW() – [Order Date]” calculates the current date/time minus your order date and will recalculate pretty much whenever you perform an action within the workbook.
“=TODAY90 – [Order Date]” calculates just the current date minus your order day and only recalculates the next day.
Bookmarks