Results 1 to 2 of 2
  1. #1
    akika is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Posts
    27

    calculate man days field in access 2016

    Hi,


    pls help.

    In access 16 forms, How can to add logic to calculate man days taken excluding weekend from fields DateStarted and DateEnded in format date/time (m/d/yyyy).

    Man days = (DateEnded - DateStarted)

    Thxs,
    A

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    The following thread should be useful: https://www.accessforums.net/showthread.php?t=74567
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Calculate working days
    By Linajkl in forum Access
    Replies: 2
    Last Post: 11-20-2018, 12:32 PM
  2. How To Calculate Days Between Dates
    By DigitalAdrenaline in forum Access
    Replies: 3
    Last Post: 08-22-2016, 10:08 PM
  3. Calculate days between two dates by VBA
    By hhuuhn12 in forum Programming
    Replies: 16
    Last Post: 12-10-2013, 03:11 PM
  4. How to Calculate days of the week
    By djclntn in forum Database Design
    Replies: 3
    Last Post: 02-26-2011, 11:10 PM
  5. calculate no. of working days
    By JOSE LUIS in forum Access
    Replies: 1
    Last Post: 02-01-2010, 03:55 PM

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
  •  
Other Forums: Microsoft Office Forums