Find most recent date in one range based on criteria, then return column from that row

[dgoodridge]

I couldn't think of a simpler way to title this

Here's my issue - I've got a table of expenses from the year, I want to get the final balance for the month from the balance column for each month. I've already created a reference cell for the first and last days of the month for something else.

Here's what I'm thinking:
Retrieve last date (largest value) from date range that spans the entire year, between my custom range [firstdayofmonth] : [lastdayofmonth], then return column value from D (balance)

I've been tracking my budget in Excel for 2 years but I've decided it's time to go pro and really make this thing amazing! Any ideas?