Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: Calculate Future Date

    I need to calculate a future date looking at only weekdays and excluding holidays in an Access 03 query

    Leadtimes in workdays - contains # of work days that need to be added to current date to get future date

    Holidays - current year holidays

    I'm not very knowledgeable in VBA and I've found several posts and gotten close, but nothing is working. Any help would be greatful!

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    You should try to get a calendar of the holidays specific to your country (official holidays vary among countries) and enter the significant part of it into a table. Several solutions are available on the net.

    From there you can compute the number of holidays for a given period and substact it (plus the weekends) from the total number of days for the same period. This would give you the number of workdays for the period.
    Have a nice day!

Posting Permissions

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