Get Month

[jkelly228]

Hello All,

I have a cell with a date in the format d/m/yyyy and I need to get the Month and put it in the format MMM. Part of the problem is that I don't know if the day number will be one or two digits, so I think I have to look between the / / marks.

How can I do this. I appreciate any help. Thanks

Kelly

[Leith Ross]

Hello Kelly,

In VBA you can simply use the Format statement.

Please Login or Register  to view this content.

[jkelly228]

Hello Leith,

This is the code I used

Please Login or Register  to view this content.

and I get the error "Type Mismatch"

Not sure if I am doing something wrong or not, but I want to apply this to the entire column "M" all the way to the last row.

Thanks for the help.

Kelly

[alansidman]

If you don't want to use code, then you can use the following formula and format it custom 'MMM'.

=MONTH(DATEVALUE(A1)). Assumes formula is in cell B1 and your date is in A1.

Just an alternative to Leith's method. Both are valid solutions.

alan

[Leith Ross]

Hello Kelly,

To apply the formatting to the entire column, use this statement...

Please Login or Register  to view this content.

[jkelly228]

Thank you both. I appreciate the help. It worked.