GRAY LEAF

TECHNOLOGY BLOG

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

by John Laub |
May 16, 2019

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,
Want More?

Get weekly up-to-date technology tips sent straight to your inbox
TOP Categories
Popular Posts

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
operationandgrowth-02