concatenate dates?

Craig AS · Apr 27th, 2002, 06:55 AM

hey,
i have 3 combo boxes, first with day numbers, second with month names, and third with years. I was just waundering if it is possible to concatenate three cells as a date. I have tried but i cannot solve it. any help is appreciated, thnx alot

Craig

Aladin Akyurek · Apr 27th, 2002, 07:06 AM

Quote:

On 2002-04-27 05:55, Craig AS wrote:
hey,
i have 3 combo boxes, first with day numbers, second with month names, and third with years. I was just waundering if it is possible to concatenate three cells as a date. I have tried but i cannot solve it. any help is appreciated, thnx alot

Craig

Since you didn't tell how you created the comboboxes and whether or not the month names are full names or 3-letter names, what follows will simply use 3 cells (A1:C1)housing a day value (a number), a month (full) name, and a year value (a 4-digit) number, respectively:

=DATE(C1,MATCH(B1,{"january";"february";"march";"april";"may";"june";"july";"august";"september";"october";"november";"december"},0),A1)

For 3-latter names adjust:

{"january";"february";"march";"april";"may";"june";"july";"august";"september";"october";"november";"december"}

Aladin

Craig AS · Apr 27th, 2002, 07:39 AM

ok sorry, i will try and explain more clearly now:

I have three combo boxes, the 1st contains day numbers 1-31. The second only contains months, 3 letters, so january = jan, febuary = feb ect.... and the the third contains this year and the upcoming year. 2002/2003, no next year it will contain 2003/2004. I have used vlookup formulas so it will look up the cell link, the show jan,feb etc.. in a cell. I have done the same for the years. However i need to transfer all the ordering information to a database on excel, but cannot find a way to get the three seperate cells of information(day,moth,yaer) into one single cell. hope this makes my problem more clear. Thanx alot

Craig

p.s. didnt understand your reply

Aladin Akyurek · Apr 27th, 2002, 07:56 AM

Quote:

On 2002-04-27 06:39, Craig AS wrote:
ok sorry, i will try and explain more clearly now:

I have three combo boxes, the 1st contains day numbers 1-31. The second only contains months, 3 letters, so january = jan, febuary = feb ect.... and the the third contains this year and the upcoming year. 2002/2003, no next year it will contain 2003/2004. I have used vlookup formulas so it will look up the cell link, the show jan,feb etc.. in a cell. I have done the same for the years. However i need to transfer all the ordering information to a database on excel, but cannot find a way to get the three seperate cells of information(day,moth,yaer) into one single cell. hope this makes my problem more clear. Thanx alot

Craig

p.s. didnt understand your reply

What are your cell links? Do these show directly the selections made?

Aladin

Craig AS · Apr 27th, 2002, 08:01 AM

hi,
my cell links was just the number relating to what i chose. e.g. january = 1, febuary = 2 march = 3, etc..... then i just looked up a table with dates in to get the date in a word(3 letters)

Aladin Akyurek · Apr 27th, 2002, 08:04 AM

p.s. didnt understand your reply

Craig,

By the way, Why don't you check the formula I provided by entering in A1, say, 27, in B1 "April" without quotes, and C1 2002 to see if it works and how it works? The formula must go say in D1.

Aladin

[ This Message was edited by: Aladin Akyurek on 2002-04-27 07:05 ]

Craig AS · Apr 27th, 2002, 09:12 AM

[ This Message was edited by: Craig AS on 2002-04-27 08:21 ]

Craig AS · Apr 27th, 2002, 09:26 AM

Hey again,

sorry to bother u again, but i have found a problem with it. for some reason it will not work with the year. #NUM! comes up in the cell. it works without the year, but the year come up as 1990 all the time, so its definetly got something 2 do with the year, but i dont know what, ne ideas?

Craig

Aladin Akyurek · Apr 27th, 2002, 09:28 AM

Quote:

On 2002-04-27 08:12, Craig AS wrote:

[ This Message was edited by: Craig AS on 2002-04-27 08:21 ]

You emptied this post!

Do you need any further assistance?

Aladin

Craig AS · Apr 27th, 2002, 09:32 AM

Quote:

On 2002-04-27 08:26, Craig AS wrote:
Hey again,

sorry to bother u again, but i have found a problem with it. for some reason it will not work with the year. #NUM! comes up in the cell. it works without the year, but the year come up as 1900 all the time, so its definetly got something 2 do with the year, but i dont know what, ne ideas?

Craig

yes i do, with the above please.

[ This Message was edited by: Craig AS on 2002-04-27 08:33 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 27th, 2002, 06:55 AM	#1
Craig AS New Member Join Date: Mar 2002 Posts: 26	hey, i have 3 combo boxes, first with day numbers, second with month names, and third with years. I was just waundering if it is possible to concatenate three cells as a date. I have tried but i cannot solve it. any help is appreciated, thnx alot Craig

Apr 27th, 2002, 07:39 AM	#3
Craig AS New Member Join Date: Mar 2002 Posts: 26	ok sorry, i will try and explain more clearly now: I have three combo boxes, the 1st contains day numbers 1-31. The second only contains months, 3 letters, so january = jan, febuary = feb ect.... and the the third contains this year and the upcoming year. 2002/2003, no next year it will contain 2003/2004. I have used vlookup formulas so it will look up the cell link, the show jan,feb etc.. in a cell. I have done the same for the years. However i need to transfer all the ordering information to a database on excel, but cannot find a way to get the three seperate cells of information(day,moth,yaer) into one single cell. hope this makes my problem more clear. Thanx alot Craig p.s. didnt understand your reply

Apr 27th, 2002, 08:01 AM	#5
Craig AS New Member Join Date: Mar 2002 Posts: 26	hi, my cell links was just the number relating to what i chose. e.g. january = 1, febuary = 2 march = 3, etc..... then i just looked up a table with dates in to get the date in a word(3 letters)

Apr 27th, 2002, 08:04 AM	#6
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	p.s. didnt understand your reply Craig, By the way, Why don't you check the formula I provided by entering in A1, say, 27, in B1 "April" without quotes, and C1 2002 to see if it works and how it works? The formula must go say in D1. Aladin [ This Message was edited by: Aladin Akyurek on 2002-04-27 07:05 ]

Apr 27th, 2002, 09:12 AM	#7
Craig AS New Member Join Date: Mar 2002 Posts: 26	[ This Message was edited by: Craig AS on 2002-04-27 08:21 ]

Apr 27th, 2002, 09:26 AM	#8
Craig AS New Member Join Date: Mar 2002 Posts: 26	Hey again, sorry to bother u again, but i have found a problem with it. for some reason it will not work with the year. #NUM! comes up in the cell. it works without the year, but the year come up as 1990 all the time, so its definetly got something 2 do with the year, but i dont know what, ne ideas? Craig