Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Range Changing Each Time Worksheet Is Opened
Easier question on this:
I have entered a cell that will change every day it is opened. How can I get an auto filter to filter all the dates in two cells to only display if they are before that date in the "current" cell? I would like to be able to have the auto filter run when the worksheet is opened without having to go to the filter dropdown. Thanks again. "Lance Hebert" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Range Changing Each Time Worksheet Is Opened
Yet another part of the question:
I would also like to have it so the auto filter will display only those records that include dates prior to the the "current" date or if the "current" date falls within the two dates range fields. I hope that is making sense to someone. "Lance Hebert" wrote: Easier question on this: I have entered a cell that will change every day it is opened. How can I get an auto filter to filter all the dates in two cells to only display if they are before that date in the "current" cell? I would like to be able to have the auto filter run when the worksheet is opened without having to go to the filter dropdown. Thanks again. "Lance Hebert" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |