Filter reports by the interval between two dates

Question

My Opportunities have Start Date and Close Date. These are treaties. Between these dates the company makes a profit. I need to show in the report how much profit the company receives in a month and a year. But the contract can start (Start Date) in March and close (Close Date) in April. For example, I need to display exactly the profit, which turned out in April, discarding the days of profit in March. How can I do it?

My wrong decision (with this decision, unfortunately, I exclude the possibility of starting in the previous month or finishing in the next month):

Answer 1

To do that you need to add your filters by THIS MONTH first for Start & Close date then add a filter logic. To add filter logic you can click to the button next to filters. Here is the documentation for adding filter logic to the reports. For your case it would be 1 AND (2 OR 3) if you have your filters in this order; Record Type, Start Date, Close Date

Don't forget to add Close Date filter again because filter logic can be applied to the filters you added to the report, not the default ones.