From Year and upto year dates need to be plotted

[Sekars]

Hello Friends

I need to plot the dates from the given year and upto next given ___ years in light yellow cells.

thanks in advance

[Pete_UK]

Do the dates in column A determine the starting date?

Pete

[FDibbins]

You will need to also specify the month and day to start from, otherwise how would we know where to start?

This works for your 1st example, I just had to add a starting day (+1)

To start the sequence (I used H2 so you can compare)...
H2=DATE(D$2,1,1)+1
Then to continue, just add 7....
H3=IFERROR(IF(H2+7>DATE($D$2+$E$2,12,31),"",H2+7),"")
copied down

Once you have added the start month and day, you can use them in the 1st formula...
H2=DATE(D$2,month-cell,day-cell)

[Sekars]

But the problem is the dates will not uniform to add 7.

[FDibbins]

That is what your sample of over 200 dates, showed. If that was not what you wanted, then please show what you want, and explain how you got that

[Phuocam]

Try this in G2:

=WORKDAY.INTL(DATE($D$2,1,0),1,"0111111")

G3:

=IF(YEAR($G$2+ROWS($G$2:G2)*7)<=$D$2+$E$2,$G$2+ROWS($G$2:G2)*7,"")

[FlameRetired]

Since the upload doesn't indicate a start month I forced them. In G2

=DATE($D$2,1,MATCH(2,WEEKDAY(DATE($D$2,1,{1,2,3,4,5,6,7})),0))+(ROW()-ROW($2:$2))*7

In M2

=DATE($J$2,7,MATCH(2,WEEKDAY(DATE($J$2,7,{1,2,3,4,5,6,7})),0))+(ROW()-ROW($2:$2))*7