# Skipping cells when moving content

#### 5p00n

##### New Member
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.

#### Attachments

• Excel Schedule insert example.JPG
160.2 KB · Views: 10

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### goesr

##### Well-known Member
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​

Replies
1
Views
244
Replies
1
Views
130
Replies
11
Views
212
Replies
1
Views
141
Replies
0
Views
115

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,233
Messages
5,768,947
Members
425,507
Latest member
AndreaWorkPlace

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back