View Single Post
  #5   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default

Hi Matt,

Write into cell C8:
=IF(MONTH($B$2)=MONTH($B$2+(COLUMN()-3)*7),$B$2+(COLUMN()-3)*7,"")

and copy this to D8:F8.

HTH,
Bernd