+ Reply to Thread
Results 1 to 2 of 2

Match year of date to year of date specific range of dates, output corresponding value.

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Dublin
    MS-Off Ver
    2010
    Posts
    17

    Match year of date to year of date specific range of dates, output corresponding value.

    Hi All,

    Basically what I'm trying to do is the following:

    Match the year of a specific date to the year in a range of dates and then output a value that corresponds with this date.

    I have attached a sample spreadsheet and screenshot which shows what I am looking to do.

    Capture.PNG



    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Match year of date to year of date specific range of dates, output corresponding value

    Try this, entered as an array formula and confirmed with CTRL+SHIFT+ENTER:

    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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. How to calculate number of months by date range for a specific year?
    By redstyles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2015, 05:53 PM
  2. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  3. [SOLVED] Count days for specific year falling within in multi-year date range
    By jslo2013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2012, 05:58 PM
  4. Replies: 3
    Last Post: 08-14-2012, 05:14 AM
  5. Replies: 3
    Last Post: 08-11-2009, 11:46 AM

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