+ Reply to Thread
Results 1 to 3 of 3

Date falls between a range and equals to another value until match

  1. #1
    Registered User
    Join Date
    01-07-2016
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    1

    Date falls between a range and equals to another value until match

    I want to find a value that corresponds to the date which falls between two dates and also equal to another cell.
    sample sheet attached. Table two amount required when table one code and billing date falls between the Valid from and to dates.
    Attached Files Attached Files
    Last edited by bijeesh; 01-18-2021 at 02:30 PM.

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Date falls between a range and equals to another value until match


    Can you please fill in the amount column manually sop we know what are the expected results?
    Thanks.

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Date falls between a range and equals to another value until match

    Also -
    In T39 the date in column B is higher than the date in column C
    Is it a mistake or on purpose?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 07-14-2017, 12:04 PM
  2. Replies: 10
    Last Post: 01-15-2017, 08:02 AM
  3. Highlight a date range if today's date falls within that range
    By sdarnell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2014, 10:03 AM
  4. [SOLVED] Formula to assign specific numbers if a date falls within a certain date range
    By headley4ever in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2014, 04:16 PM
  5. Search date range +/- 7 days and return date that falls within range
    By tlafferty in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2013, 03:26 PM
  6. Replies: 15
    Last Post: 04-08-2013, 12:40 PM
  7. Mark cell if location matches and date falls between date range
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2012, 07:54 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1