Hi Walter,

Am Thu, 27 Jun 2013 10:51:33 +0200 schrieb Claus Busch:

try:
=MATCH(AL9,TEXT(ROW(1:12)*28,"MMMM"),0)

I don't know if this will work in a english excel version:
=MONTH(AL9&1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2