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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date filter in a pivot table 1
date / time format - and nested formulas selecting from a range 3
Date Range Changing Each Time Worksheet Is Opened 2
filtering dates in a Pivot Table Report Filter 3
Advanced filter 7
AUtofiltering dates 1
Auto Filter Help 2
MS Query - Filtering all dates greater than the current date 1

Back
Top