Harlan,

I know that you will have a reason for it so can I ask you why:

=MONTH(AN2&"-1")


When =MONTH(AN2&"0"), (or any other number from -99 to 99), seems to do the
same thing?


--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Harlan Grove" wrote in message
ups.com...
Harlan Grove wrote...
...
One way,

=MATCH(AN2,{"Jan","Feb","Mar","Apr","May","Jun", "Jul","Aug",
"Sep","Oct","Nov","Dec"},0)

And a simpler way,

=MONTH(AN2&"-1")