Hello,
Please keep in mind I've only recently started using these functions, as well as macros. So I'm a newb.
I'm creating a dynamic vacation calendar. I've got the week ends on conditional formatting, and they automatically adjust to match the year when I change it.
My problem is that I can't do the same thing with holidays, because if a workday Holiday falls on a week end, our actual day off is the following Monday, or the previous Friday. (Except things like good Friday that are not based on dates)
I was just going to forget about holidays, but then I thought I could just create a formula that has each date check if the previous or following day is both a holiday and a week end day, and then change color if both conditions come up true. But I have no idea how to do that. (I'm also trying to figure out how to set conditional formatting for things like good Friday, I KNOW it should be simple. I've been looking at that sheet too long.)
Bookmarks