+ Reply to Thread
Results 1 to 2 of 2

formula to calculate # of days between two dates and three dates without counting weekends

  1. #1
    Registered User
    Join Date
    10-30-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    formula to calculate # of days between two dates and three dates without counting weekends

    Hello,

    I would like to determine how long it would take to process a service request from the time it is received (opened) to the time that the client received the requested services (i.e. completed/closed).

    Looking for a formula to calculate between the two dates (Open Date and Completed/Closed) dates without counting weekends and statutory holidays.

    Also looking for a formulat to calculate between three dates (Open Date, Order Date and Completed/Closed Date) without counting weekends and statutory holidays.

    The months involved in the is calculation are July, August, September and October. The holidays in these months are: July 2, August 6, September 3 and October 8th.

    Thank you

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,788

    Re: formula to calculate # of days between two dates and three dates without counting week

    try using =networkdays()
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1