Results 1 to 2 of 2

Thread: Check date falls between period
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2006
    Posts
    923
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Check date falls between period

    I have a table as follows

    Row 1 03-Mar-20... 03-Mar-21... 03-Mar-22... 03-Mar-23... 03-Mar-24...
    Row 2 02-Mar-21... 02-Mar-22... 02-Mar-23... 02-Mar-24... 02-Mar-25...
    Row 3 T1... T2... T3... T4... T5... .. up to T10

    I am looking for an Index/Match type of formula, so if I give a specific date for example 05-Jun-23, it would return "T4".

    The period dates are always sequential and do not overlap.

    Any help is much appreciated.
    Last edited by neodjandre; Oct 10th, 2019 at 12:47 PM.

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,259
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Check date falls between period

    Why would 05-Jun-23 return T4?

    T4 is the fourth column according to row 3

    Row 2 and Row 1 data for fourth column is 02-Mar-24 and 03-Mar-23.
    That date range is outside of 05-Jun-23
    So why should T4 be returned?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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