Results 1 to 8 of 8

Count working days and toggle include today or not, taking into account holidays

Threaded View

D.Lovell Count working days and toggle... 10-13-2015, 04:16 PM
Jonmo1 Re: Count working days and... 10-13-2015, 04:37 PM
pjwhitfield Re: Count working days and... 10-13-2015, 04:44 PM
D.Lovell Re: Count working days and... 10-14-2015, 02:45 PM
Jonmo1 Re: Count working days and... 10-14-2015, 02:50 PM
Jonmo1 Re: Count working days and... 10-14-2015, 03:14 PM
D.Lovell Re: Count working days and... 10-14-2015, 03:19 PM
Jonmo1 Re: Count working days and... 10-14-2015, 03:25 PM
  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    England
    MS-Off Ver
    2007
    Posts
    191

    Count working days and toggle include today or not, taking into account holidays

    In the attached example I am counting the number of working days in the current month excluding holidays, where the holiday dates are input by the user. It also lists the number of working days so far, and the number remaining (again also taking into account any holiday dates entered).

    I have a couple of issues here that I need help with please if possible.....

    Firstly I find myself having to put a -1 in at the end of the formula for total working days some months, but not others... but I can't figure out why this happens.

    Secondly, and this is the main thing I want help with... On a given day, the formulas will calculate the number of days to go and days remaining including today. I want the user to be able to decide easily if today should be included or not without having to edit the formulas.
    So I added a checkbox for 'include today', and do a plus or minus 1 on the formulas for whether it's checked or not (using a linked cell), and realise its going to be rather more complicated due to having to take into account todays date.

    Whether the checkbox is checked or not should effect the number working days left to go, and the number remaining, only if today is a working day, ie. today is not a weekend day or one of the holiday dates input by the user. This surely is doable but I think a little beyond my current skill level.

    I think you will get what I mean if you have a go at the example, any help is much appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display last working day of month, taking into account national holidays?
    By will1565 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-29-2015, 06:53 PM
  2. SLA Status formula taking into account Business Days
    By Chris_Mck in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2015, 06:34 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 Working days by subtracting bank holidays and weekends
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2014, 07:40 AM
  5. Replies: 5
    Last Post: 05-18-2012, 10:24 AM
  6. Replies: 3
    Last Post: 03-09-2012, 08:19 AM
  7. If statement to include working days, exclude holidays
    By rhudgins in forum Excel General
    Replies: 2
    Last Post: 05-27-2010, 09:46 PM

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