problem with dates

[Craig AS]

Hey,
I have three combo boxes with the 1st containg the day, and the second containing the month and the third containing the year.
The problem is that i must copy and paste the date to a seperate data base, however it is not possible to copy the date straight from the combo box. so i have made a link to a seperate cell, but i am unable to concatenate these three into one cell and format it as a date. The date setup that i want iss dd/mm/yyyy. Any help would be good.
Thanx
Craig

[Audiojoe]

If you send me your email address I'll send you a little calendar that I made for a userform, which is quite cool. It does exactly what you want it to do

[Craig AS]

hey thnx alot,

my e-mail is
craig_devlin@hotmail.com

[Audiojoe]

I've sent it, if you need to know anything about it, just ask

Audiojoe
Wow, look at us now, flowers in the window

[Aladin Akyurek]

On 2002-04-11 01:29, Craig AS wrote:
Hey,
I have three combo boxes with the 1st containg the day, and the second containing the month and the third containing the year.
The problem is that i must copy and paste the date to a seperate data base, however it is not possible to copy the date straight from the combo box. so i have made a link to a seperate cell, but i am unable to concatenate these three into one cell and format it as a date. The date setup that i want iss dd/mm/yyyy. Any help would be good.
Thanx
Craig

I see I failed to post or it's just vanished.

Here what I wanted to say.

If you created the comboboxes thru Toolbars|Forms, and your cell links are, say, A1, B1, and C1 and associated input ranges, say, List1, List2, and List3, use:

=DATE(INDEX(List3,C1),INDEX(List2,B1),INDEX(List1,A1))

If A1, B1, and C1 contains the relevant values directly, use (as Ian Mac also noted):

=DATE(C1,B1,A1)

Aladin

[ This Message was edited by: Aladin Akyurek on 2002-04-11 02:48 ]

[Ian Mac]

On 2002-04-11 01:29, Craig AS wrote:
Hey,
I have three combo boxes with the 1st containg the day, and the second containing the month and the third containing the year.
The problem is that i must copy and paste the date to a seperate data base, however it is not possible to copy the date straight from the combo box. so i have made a link to a seperate cell, but i am unable to concatenate these three into one cell and format it as a date. The date setup that i want iss dd/mm/yyyy. Any help would be good.
Thanx
Craig

chack out the date function:

=date(year,month,day)

if your linked cells are

A1 = Day
A2 = Month
A3 = Year... put:

=date(A3,A2,A1)

and format how you wish.