How do I create a calculated date column in SharePoint to determine if 30 days have passed?

Using calculated columns in SharePoint can be useful for logical operations. Here's an example on how to create a calculated date column to determine if 30 days have passed.

  1. Create a date column named “Date” and save.
  2. Create a calculated column with data type “Yes/No” with this formula: =(Date+30)<TODAY()

Here’s how the result should look:

SharePoint, Library, List, Calculated Column,

The right technology decisions will help unleash your company’s potential

Gray Leaf helps you modernize your tech
and streamline your business

Let's Chat