Results 1 to 2 of 2

Thread: Evaluate Date Field and Determine Week Number - HELP!

  1. #1
    Seeker pbsmith82's Avatar
    Join Date
    May 2016
    Posts
    10
    Articles
    0
    Excel Version
    Excel 2016

    Evaluate Date Field and Determine Week Number - HELP!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,436
    Articles
    0
    Excel Version
    Office 365 Subscription
    INDEX MATCH with an approximate match setting:

    =INDEX(week_numbers,MATCH(date,start_dates,1))
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •