concatenate dates?

[Craig AS]

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]

On 2002-04-28 09:46, Craig AS wrote:
hey,

ok i'll send my work, u have wuzip dont u? coz my file wont fit otherwise. Ne way, thanx alot.

Craig

Yes, I do.

 

[Craig AS]

have u had my project ok?

 

[Aladin Akyurek]

On 2002-04-28 10:30, Craig AS wrote:
have u had my project ok?

Looks good.

I named your 1-column list of day numbers in Places DLIST, your 1-column list of 3-letter month names MLIST, and your 1-column list of years YLIST.

Guess what: You didn't tell that YLIST is populated by using formulas that compute a date by referring to a cell containing =TODAY(), which means that the first item is in fact in that list is today's date and not simply 2002. You should have told that .

I replaced the Input range values in all of your comboboxes by their respective names.

The formula for the departure date becomes simply:

=DATE(YEAR(INDEX(YLIST,D29)),C29,B29)

and for the return date:

=DATE(YEAR(INDEX(YLIST,D31)),C31,B31)

Aladin

PS. I'll send you your updated WB back.

 

[Craig AS]

hey thnx alot 4 that

it works gr8, thanx alot again

craig