I have single text for Month.

I want to create View with filter with Month.

Example :Month is equal to the current month formula is =MONTH([Today])

But it is not working.

  • 1
    It is not working since you have Month as a single text instead of Date Time field Mar 30, 2015 at 7:04
  • @ArsalanAdamKhatri So,I need to create one more column and field as a today date. And then how is the formula? Mar 30, 2015 at 9:03

3 Answers 3


You need to add two calculated columns that will work out the start and the end of the month. (This example uses [Due Date] but you can use any date/time column)

"Start of Month" =DATE(YEAR([Due Date]), MONTH([Due Date]), 1)

"End of Month" =DATE(YEAR([Due Date]), MONTH([Due Date])+1,1)-1

Then you setup a filter in your view for...

"Start of Month" is less than or equal to [Today] AND "End of Month" is greater than or equal to [Today]

  • I used a very similar calculation to this, however instead of ([Due Date]) I used (Created). Sep 26, 2017 at 12:05

You have to create the couple of columns with Date time type and calculated type in order to get this.

Check this

A sharepoint list view of the current month

List View: Automatically Filter by Current Day, Month or Year


Start and end of month calculated columns can be used to fix this.

Try this link.

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.