+ Reply to Thread
Results 1 to 3 of 3

Subtract Dates excluding Saturdays and Sundays

  1. #1
    Registered User
    Join Date
    09-17-2003
    Location
    Scotland
    Posts
    59

    Subtract Dates excluding Saturdays and Sundays

    I want to calculate the number of days between 2 dates but want to exclude dates which fall on Saturdays or Sunday in any calendar year. Does anyone know a formula to do this.

  2. #2
    Registered User
    Join Date
    12-20-2004
    Location
    Sandviken, Sweden
    Posts
    6

    Subtract Dates excluding Saturdays and Sundays

    Hi

    In excel every day is represented by a number 1-7
    Snip from VBA help:
    -----------------------------------------------
    Argument Values

    The firstdayofweek argument has the following values:

    Constant Value Description

    vbUseSystem 0 Use NLS API setting.
    vbSunday 1 Sunday (default)
    vbMonday 2 Monday
    vbTuesday 3 Tuesday
    vbWednesday 4 Wednesday
    vbThursday 5 Thursday
    vbFriday 6 Friday
    vbSaturday 7 Saturday
    -------------------------------------------------

    look at this howto: http://www.cpearson.com/excel/distribdates.htm

  3. #3
    Registered User
    Join Date
    01-22-2004
    Location
    UK
    Posts
    27
    You need to make sure you have the Analysis toolpack installed.

    Tools>addins make sure Analysis Toolpack is ticked (if not tick it now, you may need your installation disk)

    Then you can use the following formula:

    =Networkdays(Startdate,Enddate,Holidays)

+ 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