P
puiuluipui
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.
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.