I'm a kiwi teaching English at a university in South Korea. Its been a while since I studied computers. As part of my preparations for the upcoming semester, I am making an excel spreadsheet:
During this semester, there will be two public holidays (highlighted yellow using conditional formatting). I have calculated my syllabus using a formula based upon when the first day of semester for each class is respectively.
How can I remove these two days (to basically shift each column 'up') without breaking the code for days following the public holiday?