• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is date X between dates A & B or C & D or E & F etc...

M

Matt Forder

New Member
Hi everyone,

In the spirit of bending Excel to do magic things I'm trying to work out a formula that will date whether a date X is between a list of dates in a table.

I have two tables of data:
  • The first table has multiple rows, each row has a unique time stamp.
  • The second table had multiple rows, each row has a cell with a start time, and an adjacent cell with an end time.
For each row in the first table I want to set the value of a cell in the row depending on whether the data stamp falls between any of start and end time listed in the second table.

For example:

If the date stamp in cell A2 of the first table is set to the date "15/12/2015 15:00:00" I'd like to update the cell B2 with TRUE if A2 falls between any of the start and end time listed in rows in table 2 below:

13/12/2015 00:00:00 and 13/12/2015 07:00:00
14/12/2015 05:00:00 and 14/12/2015 05:30:00
etc..

Any thoughts on how this might be achieved? I'm sure the answer is straight-forward but it's vexing me!

Thanks in advance,

Matt Forder
 
You must log in or register to reply here.
Back
Top