If then Date Ranges

M

Mark B

I want to pull in to Sheet 1 a list of names from another sheet based upon a
date range in the second sheet...

In my example, the reason Fred is in ColA on Sheet 1 is because his date
range in Sheet 2 matches this formula... ColB<=01-21-06 AND ColC >=01-21-06


Sheet 1 Sheet 2
ColA ColB ColA ColB
ColC
1-21-06 1-28-06 Fred 1-19-06
1-24-06
Fred Lucy Ethel 1-19-06
1-24-06
Ethel Ricky Lucy 1-26-06
1-30-06
Ricky 1-26-06
1-30-06
 

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

BETTER SPACING - If Then Date Range 7
IF AND Function Date Range Issues 6
Sum amount of days in another coloumn 8
Count based on multiple criteria 2
IF ARRAY with multiple conditions. 1
Modifying a complex date formual to count months 4
Return a Value between dates based on another Value 3
Date Function 2

Top