View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T.O. T.O. is offline
external usenet poster
 
Posts: 1
Default 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