Find value for last day of month with data

[maacmaac]

I have a table with daily data for past three years. I trying to find an easy way to find the value for the last day of each month with data and populate a monthly table.

For example, the last three days of Jan-2008 are as follows:
1/29 = 5000
1/30 = 5500
1/31 = 6000

The last three days of May-2008 are as follows:
5/29 = 12000
5/30 = 13000
5/31 =

For this example, I want to populate the closing value for each month. For January, the closing value is 6000; for May, the closing value is 13000 (there is no data for 3/31, so it uses the next prior day with data.

Attached is sample of data table and monthly table (monthly table includes sample of desired output). Thank you in advance for any comments.