Results 1 to 2 of 2

Thread: Holidays AND Weekends

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2000


    I have two fields, OrderDate and ShipDate. I want to calculate the number of days between these two dates. However, I want to Subtract Weekends and Holidays from this total. I have a Holiday table in the DB. Does anyone have a suggestion on the best way to accomplish this?..I have VB6 and Access97....thank you

  2. #2
    Maybe I'm missing something here, but:

    Date1-Date2 = X days

    X\7= Y Weeks (Note the integer division)

    2*y = Z Number of week days

    X - Z = number of work days

    Now subtract off the holidays and you have the number of
    work days.

    You'll also have to check the remainder days (X - (Y*7)) to
    see if a Sat or Sunday is included.

    Good Luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width