Copy latest date of every month from a column in excel 2007

Hi,
I'm new here and I desperately need help in my work. I have a spreadsheet with test data. Column A has the dates from 1878 to 2013 and column B to D have the test results. Some months had two or more tests done and some had just one. Is there a way I can collect only the data for the last entry for the month. Below is the example:

10/1/1984 902 437 8
10/12/1984 959 473 8
10/18/1984 989 488 9
10/26/1984 1,030 506 9

I just want to copy the row for 10/26/1984 and ignore the rest. This occurs for multiple months and I don't want to got through the entire spreadsheet copying them one after the other. Help Please!!!

Thanks

Given that the data is sorted by date, try the macro included and the last entries of each month are listed in sheet2

Thank you rcm. I was wondering if there is there a way to do it without macros.

No that I know of, but it can be automated to changing values or a row is added on the sheet or triggered by a button inserted in the sheet or anywhere int the workbook.

Thank you guys for your help. And yes, that was supposed to be 1978 not 1878.