How to Avoid Holidays



1 comment

  • Avatar
    Service Desk

    Fun question! At the end of the offset you've built, tack on two additional sentences:

    1.  Minus 1 calendar day.

    2.  Plus 1 business day.

    Sentence #1 moves a day backward (to the Sunday preceding your Monday).  Sentence #2 moves forward to Monday unless Monday is a holiday, in which case it moves to Tuesday.

    Originally submitted by Scott Campbell

    Comment actions Permalink

Please sign in to leave a comment.