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.
 
Back
Top