Insert days/dates from the 1st of the month in a register, its not that simple.

Hi All, I am not sure if this is in the correct bit of the forum, not sure if it can be done with formulas or if it needs code or a combination.

The sheet attached is a register I send out to our swim club, currently we have a 5 week register and send a new register ready to be used before the last one runs out, so on the register attached I would have sent out a new register before 4/11/12.

Currently I run a marco from a master file that has all the names of the swimmers, this opens the register file and inputs all the data required for each squad, I have popup input boxes in the macro so I can input the 1st date of the month which has always been the first Monday in the month, I also input what month and year as this is how the file is automatically saved.

My issue,

I have been asked do the registers monthly, so I send out ready for the 1st of the month each time regardless of what day the 1st of the month is, normally not an issue but if you look at the attached file on the performance tab to start with you will see we swim twice on a Tuesday and swim and land train on a Thursday and Sunday and don't swim on a Friday.

I can obviously put the 1st of the month in through the Macro and then get the day from that date.

How can I get the rest of the month to fill across the days and dates?

Added issues U can see,

If the 1st of the month is a Friday.

I need to do this for each squad and the all have different swim schedules as you can see from the attached sheet.

I have been thinking about this for a while now and am really struggling.

Hope someone can help.

Darren