software

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?--
Igottabeme
------------------------------------------------------------------------
Igottabeme's Profile: www.excelforum.com/member.php...oamp;userid=33699
View this thread: www.excelforum.com/showthread...hreadid=534764What 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

quot;Igottabemequot; gt; wrote
in message ...
gt;
gt; Let's say I have thousands of employees, but I need to determine who
gt; worked for me during a particular date range, and all I have to go on
gt; is their start date in one column and their end date in another
gt; column.
gt;
gt; If:
gt;
gt; A1 contains beginning date of employment
gt; B1 contains ending date of employment
gt; C1 contains specified beginning date (criteria)
gt; D1 contains specified ending date (criteria)
gt;
gt; is there a formula to help make this determination?
gt;
gt;
gt; --
gt; Igottabeme
gt; ------------------------------------------------------------------------
gt; Igottabeme's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33699
gt; View this thread: www.excelforum.com/showthread...hreadid=534764
gt;
If this were me, I would create a helper column with the formula:

=if(or(and($c$1gt;a1,$c$1lt;b1),and($d$1gt;a1,$d$1lt;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.

--
Regards,
Fredquot;Igottabemequot; gt; wrote in
message ...
gt;
gt; Let's say I have thousands of employees, but I need to determine who
gt; worked for me during a particular date range, and all I have to go on
gt; is their start date in one column and their end date in another
gt; column.
gt;
gt; If:
gt;
gt; A1 contains beginning date of employment
gt; B1 contains ending date of employment
gt; C1 contains specified beginning date (criteria)
gt; D1 contains specified ending date (criteria)
gt;
gt; is there a formula to help make this determination?
gt;
gt;
gt; --
gt; Igottabeme
gt; ------------------------------------------------------------------------
gt; Igottabeme's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33699
gt; View this thread: www.excelforum.com/showthread...hreadid=534764
gt;