Originally Posted by
MarvinP
Hi,
I thought you'd skip ahead 14 days if you hit one of those vacation dates. I think you are better off to simply do a manual date input for the ranges below those vacation dates. I don't really know what to keep and what to move. I did see the formula breaks when you delete the yellow cells, but I didn't know what you wanted to replace them with. Do you want them to go blank for those dates? If so you could Conditional format the text of those dates to match the background color. I'm still at a loss on what you want.
Bookmarks