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!

if((and(a2="m",d2>=38854,d2<=38888),"June",if(and(a2="m",d2>=38889,d2<=38916),"July","unknown"))

but a vlookup could be easier if you are going to expand to other months
=if(a2="m",vlookup(d2,a1:b10,2),"unknown")

where column a has the start dates of each of your ranges and b the corresponding month

Regards

Dav