Didn't test this, but it'll be something like this:

IF(AND(AND(MONTH(A1)=6,DAY(A1)=7),AND(MONTH(A1)< =8,DAY(A1)<=20)),A1,"")

Good Luck
Duke


"Art Stewart" wrote in message
...
Wow, this method works wonderfully, simply fantastic, what a time saver.
Thank you so much.

After such a great answer to my question I hate to ask another question
so,
please, bear with me.

Now the question is how to include days in the formula just provided?
Such
as the range from 6/7 thru 8/20 for example.

Thanks again for your kind help.
Art


"CLR" wrote in message
...
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