Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jack
 
Posts: n/a
Default 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   Report Post  
Dave R.
 
Posts: n/a
Default

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   Report Post  
jack
 
Posts: n/a
Default

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   Report Post  
jack
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tallying columns based on values of 2 different columns Mctabish Excel Worksheet Functions 1 January 30th 05 11:40 AM
Totalling values across columns Glenn Excel Worksheet Functions 3 January 26th 05 02:47 AM
SUM values between dates Qaspec Excel Worksheet Functions 1 January 19th 05 04:45 PM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 01:47 AM
Need to sum values of columns 1 - 13 and 4 - 15 ExcelHelp Excel Worksheet Functions 1 October 27th 04 07:03 PM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"