Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing linked worksheet and range of cells | Excel Discussion (Misc queries) | |||
excel file opened automaticaly at specified time & date | Excel Discussion (Misc queries) | |||
how do i enter date and time in cell without it changing | New Users to Excel | |||
how do i enter date and time in cell without it changing | Excel Worksheet Functions | |||
Changing date and time to date only | Excel Worksheet Functions |