In H6 Cell


=IF($J$4="Weekly",$R$4+((COLUMNS($A:A)-1)*7),EDATE($R$4,COLUMNS($A:A)-1)-WEEKDAY(EDATE($R$4,COLUMNS($A:A)-1),15)+1)


Drag it right...