Dates in excel - PLEASE help

[mikmayer]

I have a "Month" column with 3000 rows that include month abbreviations (in text form, not date formatted) like "Mar" "Apr" "Aug" etc. However, I need them to include the year (2012), so the entries will read "12-Mar" "12-Apr" "12-Aug" etc.


Is there an easy way to do this? Any help would be appreciated!

 

[mercatog]

Hi mikmayer


If in A2 you have for example Apr


In B2, Try this formula =TEXT(DATEVALUE(A2 &" 2012"),"yy-mmm")


Regards

 

[mikmayer]

Mercatog,


Thanks so much for your quick response. It worked wonderfully and just made my work day a lot easier.

 

[bobhc]

Good evening mikmayer

This is the formula in B1 to get the output you want ie 12-Jan.....=CONCATENATE(12&"-",A1)

[pre]

A        B
Jan	12-Feb
Feb	12-Feb
Mar	12-Mar
Apr	12-Apr
May	12-May
Jun	12-Jun
Jul	12-Jul
Aug	12-Aug
Sep	12-Sep
Oct	12-Oct
Nov	12-Nov
Dec	12-Dec

[/pre]

 

[SirJB7]

@b(ut)ob(ut)hc

Hi, old god!

Good afternoon.

Simple and nice, if I were mikmayer I'd stick with this one unless I need to use it as a numeric date value.

BTW, you could shorten it (remember oldchippy's motto) to:

="12-"&A1

Regards!

 

[bobhc]

SirJB7 Good evening old friend, a nicer way of doing the job

 

[Luke M]

I've always found it a sick joke of Microsoft that they made a function with a giant name that's completely un-needed. Not only does it take longer to type, but it has a 30 argument limit. =(

 

[SirJB7]

@Luke M

Hi, 2nd 3K man!

Maybe it's from the same guy (or a close relative) that coded the BAHTTEXT and DATEDIF functions.

Regards!