Sorting huge list of dates

Hi there,

I have aroudn 1000 entries, each with a corresponding date over a 5 week period. I'm trying to either create a formula or write
a basic VBA script (brand new to VBA) to go through the five weeks of data and print out the date of the end of each week (Friday).
So for example, if I have a bunch of dates ranging from, say, 6/11/12 to 7/11/12, I want to be able to print out
5 dates: 6/15/12, 6/22/12, 6/29/12, 7/6/12, and 7/13/12, as these are the Fridays (week end) of each of those weeks.

Any ideas of how to approach this?

Thanks!