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 |
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 |
All times are GMT +1. The time now is 03:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com