Need Way to Automatically Select Data

[Art Stewart]

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

 

[CLR]

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]

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

 

[Duke Carey]

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

 

[CLR]

You're very welcome Art.....thanks for your kind feedback. Sorry I was away
and didn't get right back on the other part of your question, but I see Duke
picked up on it, and although I didn't test it either, it does look like how
I would have answered...........so, hope it works for you but if for any
reason you need to, come on back and don't feel like you don't deserve,
we're all happy to help.......

Vaya con Dios,
Chuck, CABGx3