we need to know how many items are there for the due date column (DueDate) for the month april and march

how do we setup a view which shows the number of items for each month ?

any help would be appreciated..


You need to create a calculated column which with formula as "MONTH([Due Date])". And data type select "Number".

Then filter the list view as calculated column equal to 3(for march) or 4(for April).

enter image description here

And in the Totals section, select Count for Due Date column (Mine is Modified column):

enter image description here

The count will return under the header:

enter image description here

  • great the solution i was looking for . – Pradeep Apr 25 '19 at 9:43

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.