Results 1 to 2 of 2
  1. #1
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    General question about due dates - Holidays - Weekends - mental gymnastic

    Hello All,



    I have read many posts about handling weekends and holidays. I have a general theory question.

    My client wants:

    If the due date falls on a Monday – I’m supposed to move it up to the previous Friday. Got that.

    If the due date falls on a holiday, and that holiday is during the week, (Tues. Wed, Thur, Fri) should I just subtract a day from the due date? And if the holiday falls on the weekend, if its Saturday, should I move it to Thursday (assuming they would have the Friday off), if its Sunday, should I move it to Tuesday assuming they’ll have the Monday off?

    Just wondering how anyone else has handled this.

    TIA

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    if you have read those posts, then you should know how to do it but to answer
    if the holiday falls on the weekend, if its Saturday, should I move it to Thursday (assuming they would have the Friday off)
    that is your business rule, or at least your company's.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-10-2014, 02:32 PM
  2. Replies: 8
    Last Post: 10-20-2012, 11:25 AM
  3. quarterly, excludes weekends and holidays
    By madagaluna in forum Queries
    Replies: 2
    Last Post: 04-01-2011, 12:56 PM
  4. Replies: 0
    Last Post: 04-01-2011, 09:12 AM
  5. How to analyze holidays/weekends
    By Galio83 in forum Queries
    Replies: 0
    Last Post: 03-31-2011, 12:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums