Date Formula Help

Here is a loom that may help get you started without doing anything too fancy. This uses a second table using the query column to bring in bills that fall within the date range.

Again, not a full solution but might get you started.