How about =MONTH(A1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"A. Toczko" wrote in message
...
I have a column of data which is dates, entered as dd/mm/yy, and formated
to
display mmm-yy. I would like to set up another column that will assign a
number for each month shown in the date column, where April is month 1,
May
month 2, etc.

Enter data in column 1 as 25/11/05, it displays as Nov-05, and in the
second
column, I need a function that will compute to 8, the month number. TIA.