Thread: [Solved] Expiry Date Excel sheet!
View Single Post
 
Old 10-18-2015, 03:29 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote