| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating a date column from seperate data
hi, i have a very large table, in which the dates are represented by 3 seperate columns: year, month and day (all integers). how can i use these 3 fields in a function (or macro) to create a fourth column, containing the date in an excel date format? i.e. if a line in my table looks like this: 1993 11 28 then i'd like to add a fourth column, reading: 11/28/1993 thanx. -- T.O. ------------------------------------------------------------------------ T.O.'s Profile: http://www.excelforum.com/member.php...o&userid=29767 View this thread: http://www.excelforum.com/showthread...hreadid=494830 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| displaying data within column | Charts and Charting in Excel | |||
| how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
