I am creating a SharePoint Critical Path list with dues dates. I would like the due dates to be calculated using an "Opening Date" - weeks out column.

I am wondering where I can set this opening date so I can use it in a calculated value column?

I would like to be able to change this one date easily and have the sheet update. Any ideas?

  • So, in your case, you have a column in your list like due date, you want to add a calculated column to calculate the weeks between today and due date? And it should be updated dynamically every day?
    – Allen_MSFT
    Jan 5 at 3:03


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.