One way..........
Put these formulas in C1 and D1 and copy down

In cell C1 put =IF(AND(MONTH(A1)=6,MONTH(A1)<=8),A1,"")

IN cell D1 put =IF(LEN(C1)0,B1,"")

Vaya con Dios,
Chuck, CABGx3


"Art Stewart" wrote in message
...
I would like to know of a way to select specific dates and corresponding
data and paste them into the next two columns.

The column A contains consecutive dates(mm,dd,yyy) covering a 30 year
period
and column B contains data corresponding to each date. A way is needed to
automate selecting and copying a specific range of dates w/data for each
month of all years then pasting to columns C and D. ie: Select the date
range and corresponding data for the range 06/01 thru 8/31 for each of the
30 years. Then paste selected cells from columns A and B to columns C and
D.
The 30 year time period will also vary in length from one study to the
next.
TIA
Art