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.
Bookmarks