+ Reply to Thread
Results 1 to 3 of 3

How to calculate the next 60 business days

  1. #1
    Registered User
    Join Date
    11-22-2015
    Location
    England
    MS-Off Ver
    2010 or 2013
    Posts
    10

    How to calculate the next 60 business days

    Hi

    I need help with the following function:

    =WORKDAYS(D2;60;Calendar!A2:A11)

    Where:
    D2 - is the start date of a request
    60 - are the number of days I want start the nex start date of request
    Calendar!A2:A11 - the days that represent the holidays

    The purpose is to return the day of the next request


    Best Regards
    Richard

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: How to calculate the next 60 business days

    Try removing the "S" at the end of "WORKDAY".

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    11-22-2015
    Location
    England
    MS-Off Ver
    2010 or 2013
    Posts
    10

    Re: How to calculate the next 60 business days

    Finish! Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate Business Days in a month.
    By Dulanic in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-15-2015, 10:43 AM
  2. Calculate business days
    By vgrandja in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-15-2013, 10:40 AM
  3. calculate Business Days
    By wambaugh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-07-2011, 10:43 AM
  4. calculate business days(where there is 6 days a week)
    By arnab0711 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-09-2011, 10:09 AM
  5. calculate business days with excel
    By hooba in forum Excel General
    Replies: 2
    Last Post: 11-26-2007, 05:26 PM
  6. [SOLVED] How do I calculate the number of business days?
    By Nelson in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 01:35 PM
  7. [SOLVED] calculate number of business days between the 2 dates
    By Mir Khan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2005, 11:25 PM
  8. How to calculate # days between business days
    By Susan Hayes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2005, 11:05 PM

Tags for this Thread

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