Results 1 to 2 of 2
  1. 08-04-2014, 07:32 PM #1
    Aosmond
    Aosmond is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2013
    Posts
    8

    Date calculation excluding the weekends


    I have a form with two fields BegDate and EndDate I want another field to calculate the difference between the two dates less the weekend. can you help what formula to use. Thank you
    Reply With Quote Reply With Quote
  2. 08-04-2014, 08:27 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Search on Net Work Days
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Difference between date/time during working hours excluding weekends
    By cec in forum Programming
    Replies: 14
    Last Post: 09-11-2013, 01:10 PM
  2. Get date (minus one day), excluding weekends & holidays in SQL Query to use in Access
    By LindaRuble in forum Access
    Replies: 8
    Last Post: 10-20-2012, 11:25 AM
  3. DateDiff Excluding Weekends
    By cs93 in forum Programming
    Replies: 1
    Last Post: 03-25-2011, 04:09 PM
  4. Weekday excluding weekends
    By jd316632 in forum Queries
    Replies: 3
    Last Post: 05-24-2010, 02:01 PM
  5. Query DateDiff calculation excluding weekends
    By Masterfinn in forum Queries
    Replies: 3
    Last Post: 04-01-2010, 09:46 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums