View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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?