create date

T

tom ossieur

Hi,

column A contains the word Jan or Feb, or...
column B contains a year
how can I combine them into a date which I can sort chronologically?


A B C
DEC 1998 should become e.g. Dec-98
DEC 1998
JAN 1997
JAN 1997
FEB 1997
MAR 1997
APR 1997
APR 1997
MAY 1997


Thanks!

tom
 
M

Max

One way ..

Assuming data in cols A & B in row2 down

Put in say, C2: =DATEVALUE(A2&B2)
Format C2 as Custom, type: mmm-yy
Copy C2 down

We can now sort cols A to C by col C ..
 
R

RagDyeR

I can't get either of them to sort!


--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

One way ..

Assuming data in cols A & B in row2 down

Put in say, C2: =DATEVALUE(A2&B2)
Format C2 as Custom, type: mmm-yy
Copy C2 down

We can now sort cols A to C by col C ..
 
T

tom ossieur

I used Max's solution and I have to admit it works perfect.

just > Data > Sort
 
R

RagDyeR

Stupid me ... tried to sort *only* the column of dates by itself, and forgot
the darned column is FORMULAS ! ! !
 
M

Max

RagDyeR said:
... tried to sort *only* the column of dates by itself, and forgot
the darned column is FORMULAS ! ! !
Click to expand...

That happens to me at times too said:
I used Max's solution and I have to admit it works perfect.
just > Data > Sort
Click to expand...

Glad it worked for you, Tom
Thanks for feedback ..
 
Top