I am setting up a class schedule that needs to account for time off during
Christmas. The classes all take the same number of work days, but some have
a 2 week vacation in the middle for the Christmas holiday. Since I am
building a class schedule for several years in advance, I need find a way to
determine if a class, based on it's ending date, will take place during the
Christmas holiday so that I can add an additional 2 weeks to the class period
and adjust the starting date. I need a way to do this that is formula based,
so that as I add new classes, I don't need to figure out whether the class
will span the holiday, but that it will be automatically figured for me.
Thanks in advance for the help.