Date Interval Predictions

[michaeloj.simpkins]

I currently have a worksheet of data containing info on invoices. One
column contains the expiry dates of the invoices. I am wanting to run a
report which will extract all the invoices that expire within the next
90 days of the report being run. Something along the lines of >Today()
and <Today()+90. Any ideas anyone?

 

[Roger Govier]

Hi Michael

Take a look at Advanced Filter for extracting the relevant lines to a
separate sheet, using the criteria you wish for dates.
For more information on this go to Debra Dalgleish's site
http://www.contextures.com/xladvfilter01.html#ExtractWs