Convert three separate columns of values to dates
 

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

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" wrote in message
...
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:

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



"Dave R." wrote in message
...

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" wrote in message

...

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." wrote in message
...
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" wrote in message
...
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

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

Thanks.


"jack" wrote in message
...
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