Thanks:  0
Likes:  0

1. 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

2. 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)

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

3. 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

4. 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

5. 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)

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.

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

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

8. 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

9. 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?

10. 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 ]

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•