|
|
#2
10-18-2015, 03:29 PM
|
||||
|
||||
If you have the expiry dates or the # days remaining in a single column, you can use Excel's filtering tools to filter that column according to whether the date/days falls within your 20-day parameter. No need for an extra sheet. Conditional formatting could also be used to automatically highlight items with less than 21 days remaining.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 macro to automatically date sheet tab
|
Jackie | Excel Programming | 13 | 05-24-2015 02:36 PM |
|
Expiry date in excel
|
splinter09 | Excel | 3 | 12-10-2014 06:09 AM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
| How to fetch data from one sheet to another with complete details and date wise as well | harisjawed86 | Excel Programming | 1 | 08-05-2014 09:10 PM |
| Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode