Are you saying that you have a column of numbers, and an adjacent column
with their associated expiration dates that could range from 0 to five
years from the current date?
______________________________
Assume:
A1: NNNNNN
B1: Expiration Date
C1: "I" class numbers
D1: "II" class numbers
E1: "III" class numbers, &
F1: "IV" class numbers
_________________________________
Insert equations such that:
G:G =IF(INT(YEAR(B1)-YEAR(Now()))=0,A1,"")
H:H
=IF(AND(INT(YEAR(B1)-YEAR(Now()))0,INT(YEAR(B1)-YEAR(Now()))<3),A1,"")
I:I
=IF(AND(INT(YEAR(B1)-YEAR(Now()))2,INT(YEAR(B1)-YEAR(Now()))<6),A1,"")
J:J =IF(INT(YEAR(b1)-YEAR($B3))5,A1,"")
____________________________________
Ben


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=543843