|
|
#3
10-25-2022, 10:26 PM
|
|||
|
|||
One possibility is to create an ODBC query based on your data table, which returns list of loans >= 3 years old to another sheet in same workbook. You can set this query to be refreshed whenever the workbook is opened.
|
| Tags |
| conditional formatting, due date, reports |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| create a report | karkey | Word VBA | 0 | 01-03-2021 08:51 PM |
 Formula indicating employees entitled to a salary increase every three years from date of appointmen
|
Marcia | Excel | 4 | 08-13-2018 03:33 PM |
|
Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date
|
mshu31 | Word | 1 | 02-09-2017 02:04 PM |
| Date range mysteriously adding 4 years | akatz85 | Excel | 7 | 03-25-2014 12:36 PM |
|
Using Field Codes to Calculate 5 years from a Date
|
vandy | Word | 1 | 09-23-2009 11:32 AM |
Windows 8 
Office 2016
Threaded Mode