Required auto fill of months using month number

[ravi2628]

HI every one,

i need a small logic if any one can help it will be very great full to me.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Calander Year[/TD]
[TD]08.2019[/TD]
[TD]09.2019[/TD]
[TD]10.2019[/TD]
[TD]11.2019[/TD]
[TD]12.2019[/TD]
[TD]01.2020[/TD]
[TD]02.2020[/TD]
[TD]03.2020[/TD]
[TD]04.2020[/TD]
[TD]05.2020[/TD]
[TD]06.2020[/TD]
[TD]07.2020[/TD]
[TD]08.2020[/TD]
[TD]09.2020[/TD]
[TD]10.2020[/TD]
[TD]11.2020[/TD]
[TD]12.2020[/TD]
[TD]01.2021[/TD]
[TD]02.2021[/TD]
[TD]03.2021[/TD]
[TD]04.2021[/TD]
[TD]05.2021[/TD]
[TD]06.2021[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Highlighted values to populated based on Month & Year Selection from Drop Down

Thanks in advance


Thanks & Regards,
Raviteja

 

[Michael M]

Assuming your first date is in place place the formula in C3 and drag across

Excel 2013/2016
	A	B	C
1	Month	8
2	Year	2019
3	Calander Year	8.2019	9.2019
Sheet1

Cell Formulas
Range	Formula
C3	=EDATE(B3, 1)

 

[ravi2628]

Assuming your first date is in place place the formula in C3 and drag across

Excel 2013/2016

	A	B	C
Month
Year
Calander Year

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]8[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]2019[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]8.2019[/TD]
[TD="align: right"]9.2019[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C3[/TH]
[TD="align: left"]=EDATE(B3, 1)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

sorry michael the logic which you have suggested not worked

 

[jasonb75]

Try this in B3
=EDATE(DATE($B$2,$B$1,1),COLUMNS($B3:B3)-1)

 

[ravi2628]

hi jason & michael,

i have got the following logic to complete the task.

thanks for you efforts

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD="class: xl65, width: 83"]Month[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year[/TD]
[TD]2019
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Calander Year[/TD]
[TD]=date(b2,b1,1)[/TD]
[TD]=edate(b3,1)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


thanks
Raviteja

 

[Michael M]

Glad WE could help....thx for the feedback..