If June / July is your only concern, then:

=if( A2 <> "m", ___whatever happens if A2 is not m____, if(
and(D2>38854,D2<=388888), "June", "July"))

Sounds like you want everything before the 19th in one month and
everything after in the next so:

=if( A2 <> "m", ___whatever happens if A2 is not m____, if(
day(D2)<19, month(D2), month(d2)+1))



Digital2k wrote:
> 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!