Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit Macro to Intended worksheet. | Excel Worksheet Functions | |||
limit on size of macro for excell97 | Excel Discussion (Misc queries) | |||
limit cell value by date | Excel Worksheet Functions | |||
macro to time limit workbook | Excel Discussion (Misc queries) | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |