+ Reply to Thread
Results 1 to 3 of 3

count calendar days excluding a list I provide

Hybrid View

  1. #1
    Registered User
    Join Date
    10-22-2019
    Location
    Clemson SC
    MS-Off Ver
    Excel 2016
    Posts
    2

    count calendar days excluding a list I provide

    I want to count 90 days from a given date including weekends. However, I do not want to count days when school is not in session. For example, from June 1st until August 15th should not be counted.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: count calendar days excluding a list I provide

    With
    A1: a start date....2019-07-15
    and this list of dates to skip:
    D1: 2019-06-01
    D2: 2019-08-15
    This regular formula returns the date that is 90 days from the start date, not counting the dates to skip:
    B1: =WORKDAY.INTL(A1,90,"0000000",D1:D2)
    Note: this pattern "0000000" flags weekend days, beginning with Mondays, with 1's. 0's flag work days.

    In that example, the formula returns: 2019-10-14 (skipping 2019-08-15)

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    10-22-2019
    Location
    Clemson SC
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: count calendar days excluding a list I provide

    I can definitely work with this! 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. [SOLVED] Count number of days excluding weekends
    By Shahbazk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2017, 04:14 AM
  2. Count Number of Days excluding Weekends (and more!)
    By eyjei in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-03-2017, 03:47 AM
  3. [SOLVED] Count 6 working days (excluding Sunday, Holidays & half days)
    By eve_star1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2015, 08:00 AM
  4. count days excluding only sunday
    By vijayaragavan in forum Excel General
    Replies: 3
    Last Post: 06-05-2014, 01:34 PM
  5. Looking for some kind of a calendar which numbering days excluding Saturday and Sunday
    By rogerthatman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2012, 07:52 AM
  6. Calendar excluding days
    By jgomez in forum Excel General
    Replies: 7
    Last Post: 01-15-2011, 05:39 AM
  7. Generating business days in a calendar month, EXCLUDING holidays
    By jacob in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-12-2005, 12:06 AM

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