Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tallying columns based on values of 2 different columns | Excel Worksheet Functions | |||
Totalling values across columns | Excel Worksheet Functions | |||
SUM values between dates | Excel Worksheet Functions | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions |