creating a date format entry from seperate integers

[T.O.]

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.

[JMay]

In d1 enter
=date(a1,b1,c1) << and format as date
where a1 = 1993
b1 = 11
c1 = 28
HTH

"T.O." <[email protected]> wrote in message
news:[email protected]...
>
> 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
>