If Statement Between 2 Dates

As per usual it's easy to google something simple as a if statement between 2 dates, but applying them to your specific situation is much harder. lol

Please Login or Register  to view this content.

Formula Reads If Column D2:D Is greater then (DATE) 3/6/2016 Then show Columns B2:B

Now my problem is i need to figure out how to choose between 2 Dates, so it would read
If Column D2:D is Between 3/6/2016 - 3/9/2016 Then Show Columns B2:B.
any help would be appreciated, i've tried tons of variations, never quite getting the formula right.

Also
Having the same problem with SUMIFS

Please Login or Register  to view this content.

Formula reads Column I is a # Value, Column H is a Name, A14 is the name to Match with, Column G is Date, and obviously the date tells it if Column G Date is More then 3/6/2016 then display Column I.
Again i Need it between dates such as 3/6/2016 - 3/9/2016 and have it return values if Column G is between those dates.
------
If The First Option is not possible the 2nd will get me the same answer, just a little more difficult to do.
Thanks

For the IF version you could use AND to create two conditions to be met. Syntax below:

Formula:

Please Login or Register  to view this content.

Similarly for the SUMIFS version you just tag on another condition and criteria at the end, as below:

Formula:

Please Login or Register  to view this content.

Does that help you at all?

BSB

Try: =SUMIFS(I2:I, H2:H, A14, G2:G,">=3/6/2016", G2:G,"<=3/9/2016")

Originally Posted by BadlySpelledBuoy

For the IF version you could use AND to create two conditions to be met. Syntax below:

Formula:

Please Login or Register  to view this content.

BSB

I Tried

Formula:

Please Login or Register  to view this content.

and it doesn't generate anything unfortunately, thank you though

Could you post a sample workbook with your attempted formulas included?
Far easier to diagnose an issue and/or provide a solution that way.

BSB

https://docs.google.com/spreadsheets...gid=1496651388
Here you go
so in Column G,H,I it has a array formula that display info for the other tab, now right now i have it displaying information On Or After X Date
But i need it to do, Between This Date and This Date then display