Formula for determining if two date columns fall within specific date range

  • Thread starter Thread starter Igottabeme
  • Start date Start date
I

Igottabeme

Let's say I have thousands of employees, but I need to determine who
worked for me during a particular date range, and all I have to go on
is their start date in one column and their end date in another
column.

If:

A1 contains beginning date of employment
B1 contains ending date of employment
C1 contains specified beginning date (criteria)
D1 contains specified ending date (criteria)

is there a formula to help make this determination?
 
What if the employees start date is before the specified start date and the
employees end date is within the specified date range (or vice versa)? Does
that count ?

Biff
 
If this were me, I would create a helper column with the formula:

=if(or(and($c$1>a1,$c$1<b1),and($d$1>a1,$d$1<b1)),true,false)

The filter the True's.

I haven't tested the formula, so it may need some tweaking, but hopefully you
get the idea.
 

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

Back
Top