Results 1 to 10 of 10

Find some value in a range (dates)

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2014
    Location
    France
    MS-Off Ver
    2010
    Posts
    18

    Find some value in a range (dates)

    Hello,

    I'm looking for a date in a range of 1-31 of every month for the next 3 years. My range is in column H and I (H=01/mm/yyyy and I=31/mm/yyyy) in column J is written jan-15, feb-15...
    In column D I have my dates (ex 15/05/2015) and in column C I want to have written only may-15.

    Formula I use is next:

    IF(ISERROR(INDEX($J$51:$J$90,MATCH(SUMPRODUCT(($H$51:$H$90<=D25)*($I$51:$I$90>=D25)*($H$51:$H$90)),$H$51:$H$9,0))),"",INDEX($J$51:$J$90,MATCH(SUMPRODUCT(($H$51:$H$90<=D25)*($I$51:$I$90>=D25)*($H$51:$H$90)),$H$51:$H$9,0)))

    But it's working only if in D I have dates from 1st to 31st january or february 2015, for the other months and years no.
    You can find attached my workbook, the IF formula is in sheet 'LOT' D25:D44
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Using VLOOKUP to find a range of dates
    By vjpemberton13 in forum Excel General
    Replies: 3
    Last Post: 04-18-2012, 02:50 PM
  2. Replies: 8
    Last Post: 02-27-2009, 06:06 PM
  3. How do I find the earliest dates in a range of dates?
    By JJ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2006, 04:45 AM
  4. [SOLVED] Find dates in a range; then sum values in that range by a criteria
    By Anders in forum Excel General
    Replies: 4
    Last Post: 10-21-2005, 11:05 AM
  5. [SOLVED] Find (Today-21) in a range of dates
    By JG in forum Excel General
    Replies: 5
    Last Post: 03-15-2005, 12:06 PM

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