If this were me, I would create a helper column with the formula:
=if(or(and($c$1a1,$c$1<b1),and($d$1a1,$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.
--
Regards,
Fred
"Igottabeme" wrote in
message ...
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:
http://www.excelforum.com/member.php...o&userid=33699
View this thread: http://www.excelforum.com/showthread...hreadid=534764