Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a date format entry from seperate integers
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 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=494831 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a date format entry from seperate integers
In d1 enter
=date(a1,b1,c1) << and format as date where a1 = 1993 b1 = 11 c1 = 28 HTH "T.O." wrote in message ... 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 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=494831 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 date entry: Cannot get away from d-m-yy entry format | Excel Discussion (Misc queries) | |||
Problems with entry of date format | Excel Discussion (Misc queries) | |||
creating a date column from seperate data | Excel Worksheet Functions | |||
Convert Text Entry to Date Format | Excel Discussion (Misc queries) | |||
A list of Consecutive Integers, can I search for missing integers | Excel Worksheet Functions |