Need help about formula (Date)

[ybr_15]

Hi, I want to create a list (Data Validation) based on the "Month; Year" column. However, I get the list that I made does not match, there is double data (Column "V", Rows 12-13). Can I be helped so that the list I make is suitable, starting from Nov-20 to Dec-21. Thank you

MY_GPP_19_TES.xlsx
	V	W	X	Y
2	Month	Month;Year		Year
3	Nov	Nov-20		2021
4	Des	Des-20
5	Jan	Jan-21
6	Feb	Feb-21
7	Mar	Mar-21
8	Apr	Apr-21
9	Mei	Mei-21
10	Jun	Jun-21
11	Jul	Jul-21
12	Agu	Agu-21
13	Agu	Agu-21
14	Sep	Sep-21
15	Okt	Okt-21
16	Nov	Nov-21
Setting

Cell Formulas
Range	Formula
V3:V16	V3	=TEXT((ROW()+8)*29,"mmm")
W3:W16	W3	=DATE(IF(ROW()+8>12,Year,Year-1),MONTH(DATEVALUE(V3&"1")),1)

Named Ranges
Name	Refers To	Cells
List_Month	=Setting!$V$3:$V$16	W3
Year	=Setting!$Y$3:$Y$3	W3:W16

 

[Phuoc]

Try this in W3:

=DATE(Year-1,10+ROWS($W$3:W3),1)

and in V3:

=TEXT(W3,"mmm")

 

[ybr_15]

Try this in W3:

=DATE(Year-1,10+ROWS($W$3:W3),1)

and in V3:

=TEXT(W3,"mmm")

Hi, Phuoc
Thank you so much. Your code work properly, I didn't even think about it.