| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
creating a date column from seperate data
Hi
Try entering in cell D1 =DATE(YEAR(A1),MONTH(B1),DAY(C1)) Copy down as appropriate. Regards Roger Govier T.O. wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
creating a date column from seperate data
the functions YEAR(), MONTH() and DAY() require a serial number, representing a whole date as input. any other ideas? please?? -- 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
creating a date column from seperate data
My Apologies
I had meant to type just =DATE(A1,B1,C1) Format the cell in your desired date format Regards Roger Govier T.O. wrote: the functions YEAR(), MONTH() and DAY() require a serial number, representing a whole date as input. any other ideas? please?? |
| Reply |
| 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 | |||
Linear Mode
