Results 1 to 4 of 4

Count Sickness days excluding weekends

Threaded View

Cliff Gathern Count Sickness days excluding... 12-04-2013, 10:24 AM
amit.wilson Re: Count Sickness days... 12-05-2013, 03:55 AM
Cliff Gathern Re: Count Sickness days... 12-05-2013, 04:06 AM
Cliff Gathern Re: Count Sickness days... 12-05-2013, 04:18 AM
  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    Tonbridge, Kent
    MS-Off Ver
    Excel 2013
    Posts
    8

    Count Sickness days excluding weekends

    Hi,
    I have a holiday and sickness chart for all of the guys in my maintenance department for the whole of next year (2014). The holidays part works fine. The sickness is split into two areas; the number of occurrences of sickness and the total number of days sick. To make the formula work for the number of occurrences it is necessary to enter sick in both Sat and Sun if the sickness spans the weekend. But we do not work the weekend and so I do not want to count those two days. The formula needs to cover the entire year (cells BL5:ZL5). The calculation that I am currently using is =COUNTIF(BL5:ZL5,"Sick")/2 (divided by two as we log a.m. and p.m. and the answer is in days). In the example attached, it would be 1 occurrence of sickness and 3 days sick, not 4 as shown.

    For completeness, the formula that I am using for the occurrences is =SUMPRODUCT((BL5:ZL5="Sick")*(BL5:ZL5<>BK5:ZK5))

    Thanks,

    Cliff
    Attached Files Attached Files
    Last edited by Cliff Gathern; 12-04-2013 at 10:52 AM. Reason: I pasted in a table but when viewd in the post it did not line up.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need Help Tracking Last 30 Days and Excluding Weekends
    By AlphaSkidz in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-02-2013, 02:21 PM
  2. how many days used excluding weekends
    By rphan in forum Excel General
    Replies: 3
    Last Post: 07-21-2011, 06:13 PM
  3. Calculating days excluding weekends
    By lbdoodle in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-26-2009, 09:16 AM
  4. number of days between dates excluding weekends
    By jimmy@9830 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2008, 03:26 PM
  5. Replies: 2
    Last Post: 04-08-2005, 03:06 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