Evaluate Date Field and Determine Week Number - HELP!

pbsmith82

New member
Joined
May 27, 2016
Messages
10
Reaction score
0
Points
0
Excel Version(s)
Excel 2016
Ok So Below is Example of my Workbook. I need to check the Create Date in Sheet 1 and see which row it falls in between in Sheet 2. Then I need to Return "Week Number" in Sheet 2 to the "Create Week" in Sheet on.

Sheet 1:
Created Date
Resolved Date
Create Week
6/3/2019 7:48
6/5/2019 10:01
Week 23, 2019
6/3/2019 16:49
6/4/2019 13:15
6/3/2019 16:53
6/4/2019 14:17
6/3/2019 17:35
6/10/2019 16:34

Sheet 2:
Week number
From Date
To Date
Week 23, 2019
June 3, 2019
June 9, 2019
Week 24, 2019
June 10, 2019
June 16, 2019
Week 25, 2019
June 17, 2019
June 23, 2019
Week 26, 2019
June 24, 2019
June 30, 2019
 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,786
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
INDEX MATCH with an approximate match setting:

=INDEX(week_numbers,MATCH(date,start_dates,1))
 
Top