Here is one alternative to an Expire list:

Enclosed zip-file:
http://www.excelforum.com/attachment...tid=3514&stc=1

Hope it can be of use.
Ola Sandström



Sample formulas:
=IF(TODAY()IF(DAY(H3)=DAY(H3+365*2);H3+365*2;H3+3 65*2+1);"Expired
"&TODAY()-IF(DAY(H3)=DAY(H3+365*2);H3+365*2;H3+365*2+1)&" days
ago";"Will expire in
"&IF(DAY(H3)=DAY(H3+365*2);H3+365*2;H3+365*2+1 )-TODAY()&" days")

: Leap-year test: IF(DAY(H3)=DAY(H3+365*2)

=IF(SUMPRODUCT(--(ISNUMBER(FIND("Expired";B3:E3))));"Y";"")

{=IF(COUNTIF('Raw Data'!$F$3:$F$9;"Y")=ROWS($A$4:$A4);INDEX('Raw
Data'!C$3:C$9;SMALL(IF('Raw Data'!$F$3:$F$9="Y";ROW('Raw
Data'!$F$3:$F$9)-ROW('Raw Data'!$F$3)+1);ROWS($A$4:$A4)));"")}

+ I included a PivotTable just as an example


+-------------------------------------------------------------------+
|Filename: xlhelp.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3514 |
+-------------------------------------------------------------------+

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