How do I pull dates which fall into the range from today until 30 days from to day?

I've been playing with it.. and VBA could definitely help.. but if you really don't want to use it.. this may help:

In column C, right next to your dates I added the formula:
=AND(B3>TODAY(),B3<TODAY()+30)
This will give me a TRUE or FALSE whether your date is within today and 30 days from now

Then to find the first date that falls into the range, I used:
=INDIRECT(ADDRESS(MATCH(TRUE,C$1:C$24,0),2))
This found the 04/29/09 date... which is good...

Now listing the next date within that range would require finding the row where this previous entry came from, then using the range from there.. so if this came from B6, then search for the next match between C7:C24
=INDIRECT(ADDRESS(MATCH(TRUE,C$7:C$24,0),2))

See here:
http://www.excelforum.com/excel-wor...nge-from-today-until-30-days-from-to-day.html