Do the following step-by-step.

1. Enter all the years, months and days in 3 columns outside the area
of the sheet you are using. Lets say these are columns AA, AB, and AC.
In AA1 to the number of years you want, enter the years. lets say
starting 1990 in AA1, 1991 in AA2, and so on. In AB1 enter Jan, AB2 Feb
and so on till Dec (enter as shown). In Ac1 enter 1, AC2 enter 2, till
31.

2. Select cell A1. Go to Data Validation. select list and in the
source, select the range AA1:AA10 (AA10 considering 10 years. Change
this to the total range you have).

3. Select cell B1. Data Validation. select list and enter source
AB1:AB12.

4. Select cell C1. Data Validation. Select list and enter the following
formula in the source:
=$AC$1:OFFSET($AC$1,DAY(DATE(A1,MONTH(DATEVALUE("1-"&B1&"-"&A1))+1,1)-1)-1,0)

5. In cell D1, enter formula:
=DATE(A1,MONTH(DATEVALUE("1-"&B1&"-"&A1)),C1)

So now you are ready to select the date through columns A, B and C. And
the date is generated in column D. You can simply copy the values down
to any number of rows in columns A, B, C, and D.

You may hide the column D if required, but still use it further for any
calculations.



Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381870