Hi there,

I have a spreadsheet with about 5000 sequential days in column A and corresponding prices in column B. I would like to copy consective sets of weeks and quarters into column c and do analyses on them, in a loop. The problem is some weeks are 4 days and others have missing data. I need to extract the data by week, 1 week at a time, for each work-week even if it is only 3 days long because of missing data.

Any help would be greatly appreciated.

Cheers,

Delberte

I have a spreadsheet with about 5000 sequential days in column A and corresponding prices in column B. I would like to copy consective sets of weeks and quarters into column c and do analyses on them, in a loop. The problem is some weeks are 4 days and others have missing data. I need to extract the data by week, 1 week at a time, for each work-week even if it is only 3 days long because of missing data.

Any help would be greatly appreciated.

Cheers,

Delberte

## Comment