Convert three separate columns of values to dates

[jack]

I have three separate columns of values:
A=day B=month C=year
Is there a function or formula which will combine the three columns into one
cell date format (mm/dd/yy)?

Any help is appreciated

Jack

 

[Dave R.]

Yes, see the DATE function. You specify the year, month, and day, and it
returns a serial number for that date which can then be formatted as a date.

 

[jack]

Dave:

Thanks for the answer, I've almost got it, I have one last stumbling block.

I took the value of the "YR" column and added 1900 to get the "coverted
year" which was used in the date/year function. The converted year keeps
showing as 1905 in all cells, no matter what the value of "converted year.



MO DAY YR converted date converted year


1 7 63 March 27, 1905
1963

Yes, see the DATE function. You specify the year, month, and day, and it

 

[jack]

Got it figured out. I had the formating of the function incorrect.

Thanks.