View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lance Hebert Lance Hebert is offline
external usenet poster
 
Posts: 1
Default Date Range Changing Each Time Worksheet Is Opened

I have a spreadsheet that includes two columns with a date in each creating a
date range based on a third column (Due Date). The two columns are dates
based on this date (ie.[{Due Date}-45] and [{Due Date]-47]). I want to create
a worksheet that will automatically filter the date range columns to those
dates that are from a certain date in the future. I don't know if I am clear
enough, but I want to make it so if I open the file today (1/22) that the
date ranges that will automatically filter would be those that are either
past or within 45 or 67 days from today's date. If anyone would have any
recommendations, I would greatly appreciate it any help you all may have.

Thanks so much.