Results 1 to 5 of 5

How to return dates that fall within a year

Threaded View

  1. 04-25-2017, 12:45 AM #3
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2504
    Posts
    13,736

    Re: How to return dates that fall within a year

    Hello leruma. Welcome to the forum.

    I took a guess.

    With random dates in sheet1 array enter this formula in Sheet2 cell B2. Fill down and across until you get blanks.

    Formula: copy to clipboard 
    =IFERROR(SMALL(IF(YEAR(INDEX(Sheet1!$B$2:$BT$6,MATCH($A2,Sheet1!$A$2:$A$6,0),))=$A$1,INDEX(Sheet1!$B$2:$BT$6,MATCH($A2,Sheet1!$A$2:$A$6,0),)),COLUMNS($B:B)),"")


    See the attached.
    Attached Files Attached Files
    Dave
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If year of a date matches the year of any date in a range of dates, return true
    By btb918 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2015, 05:30 PM
  2. [SOLVED] Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks
    By KAPearson in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-28-2015, 03:05 PM
  3. Pull dates from multiple columns that fall into the same month/year.
    By safrau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2014, 12:15 PM
  4. [SOLVED] Require a formula to see if 2 dates fall within Year end and Start
    By john dalton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-06-2014, 09:12 AM
  5. [SOLVED] return a value in a range if cell has date that fall between two dates
    By preciouslife73 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-12-2013, 09:14 AM
  6. Using COUNTIF to return the sum of dates that fall within a Month/Year range.
    By avidcat in forum Excel General
    Replies: 4
    Last Post: 01-20-2010, 10:10 AM
  7. Check If 2 dates (or any dates in between) fall in Tax Year
    By gdbutcher in forum Excel General
    Replies: 2
    Last Post: 07-12-2009, 04:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1