Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How do I create an automatic date entry? | Excel Discussion (Misc queries) | |||
Date format issue | New Users to Excel | |||
how to create a new sheet with today's date | Excel Discussion (Misc queries) | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) |