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.