Filtering Dates

  • Thread starter Thread starter therd
  • Start date Start date
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?
 
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
 
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.
 
Back
Top