If a date is between 2 different Dates then Return Week Number

[SiuGuy007]

I am not 100% sure how to write the formula for this? On Sheet 1, I have various dates for new hired EE's. On Sheet 2, I have a list of "From Date" and "To Date", with the corresponding Week number.

If the New Hired EE date falls between the From and To Dates, I need to have the result return the week number.

[TABLE="width: 460"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]From Date[/TD]
[TD]To Date[/TD]
[TD]Week number[/TD]
[TD][/TD]
[TD]New Hire EE[/TD]
[/TR]
[TR]
[TD]January 1, 2018[/TD]
[TD]January 7, 2018[/TD]
[TD]Week 01[/TD]
[TD][/TD]
[TD]1/4/2018[/TD]
[/TR]
[TR]
[TD]January 8, 2018[/TD]
[TD]January 14, 2018[/TD]
[TD]Week 02[/TD]
[TD][/TD]
[TD]1/5/2018[/TD]
[/TR]
[TR]
[TD]January 15, 2018[/TD]
[TD]January 21, 2018[/TD]
[TD]Week 03[/TD]
[TD][/TD]
[TD]1/6/2018[/TD]
[/TR]
[TR]
[TD]January 22, 2018[/TD]
[TD]January 28, 2018[/TD]
[TD]Week 04[/TD]
[TD][/TD]
[TD]1/7/2018[/TD]
[/TR]
[TR]
[TD]January 29, 2018[/TD]
[TD]February 4, 2018[/TD]
[TD]Week 05[/TD]
[TD][/TD]
[TD]1/8/2018[/TD]
[/TR]
</tbody>[/TABLE]

Any assistance is greatly appreciated.

SIUGuy007

 

[jtakw]

No problem, just wasn't sure what you were after, here you go:

Book1
	A	B	C	D	E
10	EE Hire Date	From Date	To Date	Week #	Results
11	4/6/2018	4/2/2018	4/8/2018	Week 14	1
12	4/14/2018	4/9/2018	4/15/2018	Week 15	1
13	4/25/2018	4/16/2018	4/22/2018	Week 16	0
14	4/25/2018	4/23/2018	4/29/2018	Week 17	3
15	4/25/2018	4/30/2018	5/6/2018	Week 18	0
Sheet44

Cell Formulas
Range	Formula
E11	=COUNTIFS(A$11:A$15,">="&B11,A$11:A$15,"<="&C11)

Formula copied down.

 

[SiuGuy007]

This worked.......I so appreciate your assistance on this! Many Thanks..

SIU Guy

 

[jtakw]

You're welcome.