I need to create a calculated column that would need to show the years since a document was published. Notice that I'm not saying [Created]. The issue is that I have a document library where our office staff upload documents. One of the required columns called "Year Published" (Number). The calculated column would calculate the difference. I tried [Year Published] - Year([Today]), but that fails as the error message I get says... "Calculated columns cannot contain volatile functions like Today and Me".

Any suggestion here?

1 Answer 1


As a workaround, you could create a date and time column called Today with Today's date as default value. Then use following formula in the calculated column.

[Year Published] - Year([Today])

enter image description here

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.