+ Reply to Thread
Results 1 to 2 of 2

Formula for shift roster

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Formula for shift roster


    I update a roster for the entire month in the attached format and intend to capture shift details.

    Row 1 indicates the holidays marked as 'H' and row 4 captures the individuals working in the night shift.

    For costing purposes I want to count how many times BB has worked the night shift in the month when the following day was a holiday.

    In this example the answer I'm expecting is 2 in Cell J2 where BB worked on 31 May and 04 Jun when the following day was a holiday

    Would appreciate some help in creating a formula to capture this info. Thanks in advance!
    Attached Files Attached Files
    Last edited by AliGW; 07-18-2018 at 11:24 AM. Reason: Irrelevant section of thread title removed.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac

    Re: Formula for shift roster

    Hi and welcome to the forum

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    should do it.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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] Day and Shift wise allocation from Roster / employee shift schedule
    By Ravi_Kadu in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-24-2017, 10:57 AM
  2. Shift Roster calculation templates
    By ImBec in forum Excel General
    Replies: 1
    Last Post: 02-02-2015, 10:20 PM
  3. Shift Roster
    By Kennedychisapa in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-18-2012, 07:43 PM
  4. Shift Roster
    By princeepm in forum Excel General
    Replies: 0
    Last Post: 03-10-2011, 12:10 AM
  5. How to create simple formula in Excel for shift roster
    By Mahaveer in forum Excel General
    Replies: 2
    Last Post: 10-29-2010, 01:39 PM
  6. Roster Day/Night Shift
    By Squallr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2010, 08:39 PM
  7. Shift Roster
    By rajbiswas76 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-15-2009, 02:41 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts