Snasui Excel Forum

Hi Dear ,

I need your help how to write formula to give outputs year from 2000 thru 2020 between a dash.
the results are in grey cells

I also attach a template

thank

Try,

D3 =IF(LEFT(B$2,4)+ROWS(D$3:D3)-1>RIGHT(B$2,4)-1,"",LEFT(B$2,4)+ROWS(D$3:D3)-1)
C3 =IF(D3<>"",A$2,"")

Thank Logic
In addition I have one more how to get all months from Jan-Oct.i mean to get January, February,March,....., October
Thanks again

Try this.

=IF(EDATE(1&LEFT(B$2,3),ROWS(C$2:C2)-1)<=EDATE((1&RIGHT(B$2,3))+0,0),TEXT(EDATE(1&LEFT(B$2,3),ROWS(C$2:C2)-1),"[$-en-us ]mmm"),"")

Thank you so much