combining fields to make a date

[g James]

I know how to parse a date field using the "data" "text to
columns" function from the menu, but I need to do just the
reverse. I have 3 fields/columns which are the year
(2001), month(6) and day(22)that I need to combine into a
date field (6/23/01) so I can analyze it.

Does anyone know how to do that?

 

[Don Guillett]

try
=b1&"/"&c1&"/"&a1