Access query - Workday function like Excel to get Date

Posted on 2008-11-04
Last Modified: 2010-04-21
I need a Workday function like in Excel to get a future date.
Excel example:
Workdate(Date,# of Days) returns future date that exludes weekends.
Question by:mlaurin
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    LVL 38

    Accepted Solution

    see this link for a DateAddW() function (W is for Workdays):

    <o/t> Hi Mx!
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    Yo pDog !!!


    Author Closing Comment

    Wow!  Thanks this is perfect!!!!  I have tried multiple variations from EE and other places that did not quite work out, so thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now