Skipping cells when moving content

5p00n

New Member
Joined
May 5, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
    Excel Schedule insert example.JPG
    160.2 KB · Views: 10

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

goesr

Well-known Member
Joined
Nov 15, 2013
Messages
678
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​
 
Master Excel Bundle

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.

Forum statistics

Threads
1,152,227
Messages
5,768,927
Members
425,506
Latest member
Coder33

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top