I'm trying to create a calculated date based on the number of days a package has been at the listed location. The formula in Excel is =(TODAY()-J2). Simple enough. However, apparently the syntax does not cross over once the spreadsheet has been imported into SharePoint as a list. What is the formula for this to create the same effect?

  • 3
    Just note though, the calculated fields are not going to auto adjust every day. They are static until someone edits the list item, or there are background processes doing nightly SystemUpdate() operations. Oct 5, 2015 at 15:50

1 Answer 1


You can create a Calculated Column on the list, with formula like



=DATEDIF([TODAY], [Created],"d")

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.