How can I create a formula that will do this: = IF cell A2 ="m" and if cell
D2 is between 5/19/06 and 6/20/06 than cell E2 ="June" + if A2 = "m" and D2
is between 6/21/06 and 7/18/06 than E2 = "July" and so on?
This is the formula I used:
=AND(A2="m")*IF(D2=38854:38888,"June")+AND(A2="m")*IF(D2=38889:38916,"July")
I either get an #Value!, or some other error. Please help!