Filtering Dates

T

therd

I have a column that includes the dates of individuals who are in or will
soon be entering our program and a second column for departure dates. How do
I filter to include only those who are currently in the program?
 
V

Victor Delta

therd said:
I have a column that includes the dates of individuals who are in or will
soon be entering our program and a second column for departure dates. How
do
I filter to include only those who are currently in the program?
Click to expand...

Does "the dates of individuals who are in or will soon be entering our
program" refer to their starts dates, DOBs, or what? If not the former, it
won't be possible to do what you want.

V
 
O

Old in Dallas

Create a column for formulae that determine a result (Y or N for example)
based on the NOW function being greater than the start date and less than the
departure date. Then filter the worksheet on that column.
 
Top