Date Interval Predictions
 

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?

Date Interval Predictions
 

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

--
Regards

Roger Govier


wrote in message
oups.com...
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?