I have a column "Document Date" which is manually entered. I would like to create a calculated column that defaults to "Yes", unless it's 30 days after the document date in which case it automatically turns to "No".

Is this possible within the confines of calculated columns? or will this require a workflow.

I'm using SharePoint 2013 on prem.

1 Answer 1


I think I've found the answer for this.

=IF(DATEDIF([Document Date],NOW(),"d")>30,"No","Yes")

With The data type returned from this formula as: Single line of text


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.