i have some code that seems simple enough but is giving the wrong result and i'm going batty:


If Month(Date) = 1 Then
    myMonth = Format(Month(Date) + 11, "mmm")
Else
    myMonth = Format(Month(Date) - 1, "mmm")
End If
For January, myMonth should be "Dec", but it keeps showing up as "Jan".
How and why?

much thanks!
steph