Skipping cells when moving content

[5p00n]

Hi All,
I use excel to make a schedule for my up coming works and jobs.
In column "A" i have the date, in column "B" i have the days of the week and in column C i have the address of the job.
As i do not work on Sundays, column C on Sundays is always blank.
"Jobs" always take several days.
I use this to schedule to weeks and months ahead.

If I have delays, or need to schedule a new job into the middle ( by 3 days for example).
Is there a way to shift everything in column C down by 3 cells, while making sure that anything that now lands on a Sunday is pushed to the following Monday, maintaining the amount of days scheduled.
At the moment I am am moving the bottom cells down 3 and working my way up through the months cell/block by cell/block having to manually move around Sundays.
Image attached.

 

[XLfriend777]

Hello 5p00n - Welcome to the forum. This may be too simplistic, but you might consider creating a calendar without Sundays using a formula something like: =WORKDAY.INTL(F1,1,"0000001"). Check out the link -> Excel formula: Add days exclude certain days of week | Exceljet . Hope this helps you get started.

My result was:

Friday, January 01, 2021​

Saturday, January 02, 2021​

Monday, January 04, 2021​

Tuesday, January 05, 2021​

Wednesday, January 06, 2021​

Thursday, January 07, 2021​

Friday, January 08, 2021​

Saturday, January 09, 2021​

Monday, January 11, 2021​

Tuesday, January 12, 2021​

Wednesday, January 13, 2021​

Thursday, January 14, 2021​

Friday, January 15, 2021​

Saturday, January 16, 2021​

Monday, January 18, 2021​

Tuesday, January 19, 2021​

Wednesday, January 20, 2021​