Hi Jonas,

try entering this in B4,

=if(DATEDIF(A4,TODAY(),"y")3,"EXPIRED","okay")

where your existing date is in cell A4, or this could be adapted for
use in conditional formatting if a visual warning is all that is
needed.
See Chip Pearson's site, http://www.cpearson.com/excel/datedif.htm, for
details of how to use this function.

Hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=505676