Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 33
Default create date

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
How do I create an automatic date entry? J.P. Excel Discussion (Misc queries) 10 October 18th 07 11:57 PM
Date format issue CindyLF1 New Users to Excel 3 June 12th 06 06:18 PM
how to create a new sheet with today's date mangesh Excel Discussion (Misc queries) 1 March 17th 06 09:08 PM
Create a button that will date stamp todays date in a cell Tom Meacham Excel Discussion (Misc queries) 3 January 11th 06 01:08 AM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"