how to summarize data group by specific date range?

Summary

want to summarize not in a regular calendar date range

Content

In OAC or DVD

For example, I have a table with  detail data from Jan. 01~ Dec. 31.

I have another table to define the date range for summary. Let's say, summarize data from Jan.01 ~ Feb.15 (start_date Jan 01, end_date Feb 15), Feb 16 ~Mar 20  (start_date Feb 16, end_date March 20)...etc. The date Range could be random depending on the business requirement.

how to summarize the data by specific date range?