0

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.

0

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, privacy policy and cookie policy

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