![]() |
#1
|
|||
|
|||
![]()
I have a large database workbook with a lot of information, but I am only concerned with one column: loan date. I want to track when the loan date is greater than 3 years old. Conditional formatting for this would be helpful, but preferably I'd like to create a report for when a date becomes 3 years old.
|
#2
|
|||
|
|||
![]()
You could FILTER that column for dates that match 3 yrs old.
Then copy/paste the results to another sheet ... and / or ... print the filtered sheet. |
#3
|
|||
|
|||
![]()
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.
|
#4
|
||||
|
||||
![]()
There are also easy Power Query possibilities. If you post a sample sheet ( no pics please) we can work on it
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
||||
|
||||
![]()
Your conditional formatting could be based on something along the lines of:
Code:
=$A2<=DATE(YEAR(TODAY())-3,MONTH(TODAY()),DAY(TODAY())) |
#6
|
|||
|
|||
![]()
Use advanced filter to filter to a new sheet.
|
![]() |
Tags |
conditional formatting, due date, reports |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
create a report | karkey | Word VBA | 0 | 01-03-2021 08:51 PM |
![]() |
Marcia | Excel | 4 | 08-13-2018 03:33 PM |
![]() |
mshu31 | Word | 1 | 02-09-2017 02:04 PM |
Date range mysteriously adding 4 years | akatz85 | Excel | 7 | 03-25-2014 12:36 PM |
![]() |
vandy | Word | 1 | 09-23-2009 11:32 AM |