+ Reply to Thread
Results 1 to 3 of 3

Counting working days but wanting to put in term dates which are not included

  1. 09-30-2015, 05:11 PM #1
    excelhelp15
    excelhelp15 is offline
    Registered User
    Join Date
    06-23-2012
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    14

    Counting working days but wanting to put in term dates which are not included

    hi. I am hoping someone can help with a date query.

    Column 1 - a set date that will be put in manually
    cOlumn 2 - a sum to work out date in column 1 minus 5 working days
    Column 3 - a sum to work out a date in column 2 minus 10 working days

    The problem I have is between these dates there may be a half term at school and I do not want the half term dates to be included in the working days, so somehow I want to say .. Take away working days but do not count any days identified as term time!

    i hope this makes sense to someone.

    Thank you
    Reply With QuoteRegister To Reply
  2. 09-30-2015, 05:31 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Counting working days but wanting to put in term dates which are not included

    The formula you want is WORKDAY().

    =WORKDAY(StartDate, Days, [Holidays])

    If you list all the dates to SKIP in M1:M10, and the start date is A1, then:

    =WORKDAY(A1, -5, M1:M10)
    Last edited by JBeaucaire; 10-01-2015 at 01:33 AM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 09-30-2015, 05:56 PM #3
    excelhelp15
    excelhelp15 is offline
    Registered User
    Join Date
    06-23-2012
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    14

    Re: Counting working days but wanting to put in term dates which are not included

    Thank you so much!!!!!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting working days
    By Philipo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-17-2015, 04:52 PM
  2. [SOLVED] formula to calculate # of days between two dates and three dates without counting weekends
    By eddisign in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-01-2012, 03:41 PM
  3. Help Working Out Relative Dates and Non Working Days
    By leungf in forum Excel General
    Replies: 0
    Last Post: 08-07-2012, 12:06 PM
  4. counting days between two set dates but with different working weeks!! eekk!
    By littlefoot in forum Excel General
    Replies: 0
    Last Post: 02-10-2012, 12:30 PM
  5. Overlaping Dates - Counting the number of days overlapped between 2 or more dates
    By cwc12 in forum Excel General
    Replies: 4
    Last Post: 12-16-2011, 02:55 PM
  6. Count Working Days between 2 dates, but return a zero if the 2 dates are the same day
    By raehippychick in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-16-2009, 05:04 AM
  7. Counting Working Days Between Dates
    By runforestrun in forum Excel General
    Replies: 0
    Last Post: 02-21-2005, 11:43 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1