Results 1 to 18 of 18

Add a between 2 dates to an IF statement

Threaded View

  1. #1
    Forum Contributor myobreportguru's Avatar
    Join Date
    09-18-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2016
    Posts
    231

    Add a between 2 dates to an IF statement

    I have the following formula and I would like to add a between 2 dates to the IF AND statement.

    =IFERROR(INDEX('Weekly Income'!$E$3:$E$50000,SMALL(IF(('Weekly Income'!$B$3:$B$50000=$F$9+0)*('Weekly Income'!$C$3:$C$50000=$F$7),ROW('Weekly Income'!$A$3:$A$50000)-ROW('Weekly Income'!$A$3)+1,""),ROWS($A$3:A3))),"")

    The formula is in D16 and the 2 dates are in E2 and E4. I have attached a cut out of what the spreadsheet looks like.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If Statement Between 2 Dates
    By Chia4 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2016, 08:19 PM
  2. If statement with dates
    By itshere in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2015, 11:33 AM
  3. HELP! IF statement containing DATES
    By ohiamluis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2013, 01:05 PM
  4. IF STATEMENT and Dates
    By gballard in forum Excel General
    Replies: 6
    Last Post: 05-30-2012, 03:31 PM
  5. IF statement and dates
    By jacko311 in forum Excel General
    Replies: 2
    Last Post: 05-15-2009, 10:20 AM
  6. using dates in IF statement
    By bigchuda in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2008, 02:55 PM
  7. Dates and if statement
    By FSCGunslinger in forum Excel General
    Replies: 7
    Last Post: 02-12-2008, 08:39 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