Hi there all excel geeks!

Im just starting to learn about VBA and excel formulas!

Im trying to create a shift pattern, based on either weeks or days, troughout a year! The actual shift pattern is based on a 2 week work period and 4 weeks off.

Table:
Column A1-A50 Names
Columns B1-A50 Starting date
Top Row Weeks or dates for a whole year.

So when you pick the starting date all the shift patterns will be generated or changed + highlighted.

I know how to generate the series of dates but cant figure out how to highlight them or put them together using a code or formula.

Thanks
TA