yogi_If Name Matches In Column D Of MASTER And Date In Column DH Of Master In The Corresponding Row Is Between Dates In Cells C1 And D1 Then return 0.5 Else 0

                                           Google Spreadsheet   Post  #1961
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    May 21, 2015

question  by J. Eric Smith:

https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/xldqi1BgpZo

Trying to do a nested If with dates, failing miserably. Please help!

So I have a fairly complex sheet that I'm trying to do too much with, but here I am. I'm trying to write a nested IF statement that will look for a name, if the name matches it then tries to match a date range. If all are true it should return "0.5", else "0"

=If(Master!D:D=A6,if(Master!DH:DH>=$C$1,if(Master!DH:DH<=$D$1,"0.5")),"0")

You can look at what I'm trying to do and what have tried at: https://docs.google.com/spreadsheets/d/1zFLHr2H0gWjwSW6xKz8e3w4XtArDa-erBhJf0u64Onc/edit?usp=sharing

It's the second sheet "Credits Earned by Date Range"

Thanks in advance for any suggestions or help.

-eric

-------------------------------------------------------------------------------------------------------