View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default 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.