Filtering a report by Calendar Month and sending report


I have a report that I would like filtering by calendar month showcasing data just for that month. I can only seem to filter the report by 'last 'x' amount of days'. Seeing as though months vary in days, the report it could show additional data not required.

I had then created some helper columns on the underlying sheets to show the month so I can filter by month, but then that is a manual process as I would have to update the filter each month with the new month. In addition the 'between' filter within the report would have to be updated manually each month too. Is there any way that this can be automated?

Thanks for your help.