Shifting cells whilst ignoring certain columns?

Hi all,

I'm creating a rather basic spreadsheet to track 'daily hours' across various people - See attached image. However, I've created the spreadsheet with multiple merged cells to showcase the 'weekend' and every other Friday is a 'catch up' day; something where no time will be pencilled in and will always be kept blank.

My question is, is it possible to highlight multiple cells (see attached image) and shift them to the right, all whilst skipping/ignoring the Friday 'catch up' day and weekend cells?

For example. I have highlighted person two's hours from the first Monday through to the second Thursday, all whilst not selecting the 'weekend' or 'catch up' cells. Now, I wanted to shift all those to the right so that the first Monday becomes free and the third Monday is taken from the previous Thursdays date.

I'm unsure if this is even possible, so please let me know if so or if I need to make amendments to the cell to showcase the above in a separate way.

Thanks in advance, all!!

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.