Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Exclamation Unanswered: Workdays Function in Access

    In MS Access 2007, Select DateDiff("d", 7/3/2012, "7/10/2012") returns 7 as the number of days between those dates.
    Is there an MS Access function that returns the number of working days?
    In this example, 7/4 is a US holiday, 7/7 is a US day off (Saturday) , and 7/8 is a US day off (Sunday).
    So the function would need to return 4, not 7.
    In excel, this function is called Networkdays. Is there something similar in MS Access 2007

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Here's two functions by Arvin Meyer that should help!

    Date/Time: Calculate Number of Working Days

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

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