In cell D1 enter:
=DATEVALUE(B1 & A1 & C1)
and format as date
--
Gary''s Student - gsnu200787


"Freida" wrote:

I have 3 columns containing month (entered as january, february,etc), day of
month, year(2007,2008,etc). I would like to create a column with the date in
regular date format (2/1/07).
Do I have to use some form of VLOOKUP together with the DATE function?