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?