Excel to pull data based on current date.

[dsawejka]

I am trying to get Excel to pull data from on sheet to another based on what the current date is, Based on 30-60-90 days out from the curent date.

So if it is the 1st of the month I want all tasks that are 30 days out to be pulled automatically on to that sheet.

Same for 60 and 90 days out.

Please help

 

[SkipVought]

hi,

MS Query: faq68-5829

Or you can use a PivotTable.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}