Return the first day from a Drop Down LIst

[cfer]

Hi,

Cell B3 has a Drop down list that one can select a month. (January, February etc)

Cell B1 has the year.

In Cell I1, I would like to have the result show as the dd/mm/yyy, were dd = 01

If B3 = October, B1 = 2011, then the result in I1 vwould be 01/10/2011.

The result would be used in another formula as a date calculation.
Any help appreciatted.

Cfer

 

[VoG]

Try

=DATEVALUE("1-"&B3&"-"&B1)

Format as Date.

 

[pushkardey]

Hi,

hope this hepls ......

=TEXT(DATEVALUE("01/"&B3&"/"&B1),"dd/mm/yyyy")

this will work if B3 = October, B1 = 2011

let me know if you need anyother clarification

 

[cfer]

Hi,

Both formula worked.

Thanks to VoG and pushkardey

Cfer