create date

's Computer Specifications

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

's Computer Specifications

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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tom ossieur" wrote:
> 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

's Computer Specifications

Hi Tom,

In C1 put =(A1&"/"&B1)*1 and format C1
as custom mmm-yyyy

HTH
Martin

's Computer Specifications

I can't get either of them to sort!

--

Regards,

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

"Max" <(E-Mail Removed)> wrote in message
news:1ED18D1A-9E58-4A3E-A384-(E-Mail Removed)...
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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tom ossieur" wrote:
> 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

's Computer Specifications

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

just > Data > Sort

"RagDyeR" wrote:

> I can't get either of them to sort!
>
>
> --
>
> Regards,
>
> RD
> ----------------------------------------------------------------------------
> -------------------
> Please keep all correspondence within the Group, so all may benefit !
> ----------------------------------------------------------------------------
> -------------------
>
> "Max" <(E-Mail Removed)> wrote in message
> news:1ED18D1A-9E58-4A3E-A384-(E-Mail Removed)...
> 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 ..
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "tom ossieur" wrote:
> > 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
>
>
>

's Computer Specifications

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

Regards,

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

"tom ossieur" <(E-Mail Removed)> wrote in message
news:FC56812A-9EF6-44A1-8B69-(E-Mail Removed)...
I used Max's solution and I have to admit it works perfect.

just > Data > Sort

"RagDyeR" wrote:

> I can't get either of them to sort!
>
>
> --
>
> Regards,
>
> RD
> --------------------------------------------------------------------------
--
> -------------------
> Please keep all correspondence within the Group, so all may benefit !
> --------------------------------------------------------------------------
--
> -------------------
>
> "Max" <(E-Mail Removed)> wrote in message
> news:1ED18D1A-9E58-4A3E-A384-(E-Mail Removed)...
> 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 ..
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "tom ossieur" wrote:
> > 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
>
>
>

's Computer Specifications

"RagDyeR" wrote:
> ... tried to sort *only* the column of dates by itself, and forgot
> the darned column is FORMULAS ! ! !

That happens to me at times too, RD <g> !

> "tom ossieur" <(E-Mail Removed)> wrote in message
> news:FC56812A-9EF6-44A1-8B69-(E-Mail Removed)...
> I used Max's solution and I have to admit it works perfect.
> just > Data > Sort

Glad it worked for you, Tom
Thanks for feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create vertical line to indicate date on chart with series of date	ryguy7272	Microsoft Excel Charting	1	11th Jan 2008 06:36 PM
Create Formula - Add # of Networkdays to a specific start date to find an end date	bdicarlo1@yahoo.com	Microsoft Excel Discussion	3	9th Jan 2007 12:40 PM
Create Formula - Add # of Networkdays to a specific start date to find an end date	bdicarlo1@yahoo.com	Microsoft Excel Discussion	0	8th Jan 2007 11:32 PM
Create a button that will date stamp todays date in a cell	Tom Meacham	Microsoft Excel Misc	3	11th Jan 2006 01:08 AM
create a task request with due date...how can i create a calendar?	kevin	Microsoft Outlook VBA Programming	1	3rd May 2004 11:42 PM