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.