date limit macro
Hi, i have a database with some cars data. And i need a formula to
notice me when an inspection expires, or some other papers expires. I have in
a row, 3 or 4 dates (and other numbers and text). I need the formula (macro),
to display in a diferent sheet, entire row with all datas, when one of this 3
or 4 dates, it's close to the actually date. And i need to notice me with 21
days before actually date.
today : 15.08.2008 (21 days before = 05.09.2008)
EXAMPLE:
B-58-ABC 06.09.2002 05.09.2008 187CMB19982455 129 / 06.09.2007
05.09.2008 Allianz 31.08.2009
When one of above dates approaches actually date (21 days before actually
date), i need the formula to display entire row in a diferent sheet. And if
it's posible the date closer to the 21 days before actually date, to be with
bold, or hihighlited.
Thanks in advance.
|