+ Reply to Thread
Results 1 to 3 of 3

Staff Absence Tracker - showing number of days and number of occasions

  1. #1
    Registered User
    Join Date
    09-11-2020
    Location
    scotland
    MS-Off Ver
    2016
    Posts
    2

    Staff Absence Tracker - showing number of days and number of occasions

    Hi all

    This is my first post, I have gone through lots of previous posts trying to find a solution

    I need to create a staff absence tracker that shows the total number of days a staff member has off in a single occasion, the total days off in a rolling 6 and 12 month period, and how many occasions there have been in a 6 and 12 month period. I have absence trigger points that I need to monitor and flag up if the staff member reaches one of the trigger points.
    I have 20 staff to monitor so not a huge job but something that automatically calculates the above without me having to look it up and work it out each time an absence comes in. Ideally I would just like to put the staff member's name (or I can have a separate s/s for each staff member) and the first and last date of absence.

    Thanks for any help you can give.
    Attached Files Attached Files
    Last edited by chergar; 09-15-2020 at 04:15 AM.

  2. #2
    Registered User
    Join Date
    10-15-2018
    Location
    London, England
    MS-Off Ver
    210
    Posts
    43

    Re: Staff Absence Tracker - showing number of days and number of occasions

    Please see the attached example. I have reformatted your data to include a range to record "sickness records" and then a summary that provides you with the automatic results. I assumed your trigger value was the Bradford Factor in which case I have also included this calculation. If you are not using the Bradford Factor then just change the calculation in column K. As for the trigger points I have also taken the liberty of created a "trigger" key to which you can adjust the values to suit and then adapt the formula in column M ("Which trigger point") as you see fit.

    Hope this does everything you need
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-11-2020
    Location
    scotland
    MS-Off Ver
    2016
    Posts
    2

    Thumbs up Re: Staff Absence Tracker - showing number of days and number of occasions

    Thank you so much, this is exactly what I need

+ 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. Replies: 12
    Last Post: 08-05-2020, 12:39 PM
  2. [SOLVED] Count days falling within given period (with criteria)(absence tracker)
    By annazet in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2020, 05:04 AM
  3. staff absence tracker inc rolling year
    By BIDD in forum Excel General
    Replies: 4
    Last Post: 09-16-2019, 02:58 PM
  4. Replies: 20
    Last Post: 09-15-2017, 12:51 PM
  5. Counting the number of periods (not days) of absence in Excel
    By petedacreep in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2016, 09:42 AM
  6. Big number of Staff - problem of replacement / absence
    By youssefoudra in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-26-2014, 10:44 AM
  7. Count the number of occasions
    By deemo in forum Excel General
    Replies: 4
    Last Post: 05-22-2009, 12:36 PM

Tags for this Thread

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