Calculated columns: Display items created this month

To view the SharePoint list items that are created this month you need to create two calculated columns and a custom view.

Add a new calculated column StartMonth and at the following formula:

=DATE(YEAR([Created]), MONTH([Created]), 1)

For the second calculated column EndMonth use the following formula:

=DATE(YEAR([Due Date]), MONTH([Due Date])+1,1)-1

Now create a new view and add the following filters:

StartMonth is less than or equal to [Today]

and

EndMonth is greater than or equal to [Today]

now you have a view for all calls created this month.

Leave a Reply

Your email address will not be published. Required fields are marked *