Macro to pick data and date (from a list of daily values ) at the end of a weekly cycle

I am trying to write a macro that will pick data and the date at the end of a weekly cycle (7 days) from a long list of data. Kindly help!