month to number
 

On Thu, 21 Aug 2003 11:50:28 -0700, "_______Tim_______" wrote:

Hi,

Can you show me how to write a macro to convert a three
place month abreviation, Jan, Feb, Mar, etc., in column Y
into a number, 1, 2, 3, etc., in column AF?

Thank You.

Regards, Tim

Here's another way: In AF1, insert the formula:


=MATCH(Y1,{"Jan";"Feb";"Mar";"Apr";"May";"Jun";"Ju l";"Aug";"Sep";"Oct";"Nov";"Dec"},0)

and copy down.


--ron