Results 1 to 4 of 4
  1. #1
    DigitalAdrenaline is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    100

    How To Calculate Days Between Dates


    Hi Guys, I've created a field to calculate number the working days between two dates but am unsure of the formula. Just wondering if someone might know? Thanks.

  2. #2
    ssanfu is online now Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,040
    Check out the "DateDiff()" function in Help.

    EDIT: Ignore this post. I missed "working days".

    Follow orange's post/suggestion.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,138

  4. #4
    DigitalAdrenaline is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    100
    Thanks Guys, appreciate that.

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

Similar Threads

  1. How can I calculate working days between two dates?
    By lleeman in forum Programming
    Replies: 11
    Last Post: 03-21-2019, 03:54 PM
  2. Replies: 5
    Last Post: 09-29-2015, 12:40 PM
  3. Replies: 2
    Last Post: 08-17-2015, 09:53 AM
  4. Replies: 2
    Last Post: 04-10-2015, 03:51 AM
  5. Calculate days between two dates by VBA
    By hhuuhn12 in forum Programming
    Replies: 16
    Last Post: 12-10-2013, 03:11 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 - Senior Forums