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.

From Date	To Date	Week number		New Hire EE
January 1, 2018	January 7, 2018	Week 01		1/4/2018
January 8, 2018	January 14, 2018	Week 02		1/5/2018
January 15, 2018	January 21, 2018	Week 03		1/6/2018
January 22, 2018	January 28, 2018	Week 04		1/7/2018
January 29, 2018	February 4, 2018	Week 05		1/8/2018

<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>

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.