How to show a list of items based on the date

I'm trying to sort out some of my non-monthly bills into a list based on what bills are due in the current month. In the example below, I have the bill name, amount due, and date. What I would like to do in E2 to G2 is list the current month's bill name, amount, and date, and then below if there are more than one bill due that month. Say for in Feb, I want the 2 bills that have a Feb due date to be listed, but no others. Then when the month gets to April, I want just the April bill to show in the list. I've tried using vlookup with index and offset, but can't seem to get the combination right.

I also have another question about the "$" I've seen in several formulas on this forum. Does using that in a formula make that value a constant for an array or am I totally off on that? Thanks in advance for the help.

Hi,

I propose a revised method using a specified date range.

See attached file - Bills v2.xlsx

Regarding the $ sigh in the formula, this formats your range or the lookup value as relative or absolute reference.

See link for further details - http://www.cpearson.com/excel/relative.aspx

Hope this helps

Thanks for the replies. I managed to figure it out based on an example close to what I wanted. And thanks Redcoal for the link. That answered my question.