Here are two options:

A2: Inspection date

Put this in a new column:
=DATEDIF(A2,TODAY(),"D")
...or this:
=IF(DATEDIF(A2,TODAY(),"D")<90,"Insp. in 90days","")

Then use Autofilter to filter all dates that are Less then 90
The second option could, also be used together with a PivotTable

Hope this helped
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=376406