Results 1 to 7 of 7

Sickness tracker with a rolling 12 months

Threaded View

  1. #4
    Registered User
    Join Date
    07-04-2019
    Location
    Shropshire
    MS-Off Ver
    2010
    Posts
    4

    Re: Sickness tracker with a rolling 12 months

    Thank you! And thanks for the tip on calculating the working days!

    Do you know what formula can be used so that any absences older than 12 months are excluded?
    I've updated the spreadsheet with an example of what I'm trying to explain, hopefully it makes sense!
    Edit: the additional row has the wrong date in - should be 2020 so that there is more than 12 months between the new absence and older periods of absence

    Thanks!
    Attached Files Attached Files
    Last edited by sophie-edge24; 07-04-2019 at 04:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-19-2018, 12:55 PM
  2. Rolling Sickness
    By OxJ in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 01-11-2017, 08:38 AM
  3. Sickness Tracker Help
    By reespring2016 in forum Excel General
    Replies: 3
    Last Post: 07-25-2016, 07:22 AM
  4. Replies: 9
    Last Post: 09-22-2015, 08:47 AM
  5. Calculating Total Sickness in a rolling 12 month Period
    By china in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-08-2015, 08:04 AM
  6. Rolling sickness tracking at work
    By dnlshllrd in forum Excel General
    Replies: 6
    Last Post: 06-19-2014, 11:20 AM
  7. [SOLVED] 90 rolling attendance tracker
    By Fuhgawz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2013, 02:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1