absences

  1. R

    Rolling Calendar Attendance and Tardy Tracker

    I'm trying to help my manager create a spreadsheet to track various types of absences and leave. I've linked the spreadsheet here to see what I have set up, but need to figure out how to extract the right data. I am looking for a way to figure out absences based on a rolling calendar year, and...
  2. W

    Please someone help me!

    Good morning everyone, I hope this is the place I can get some help with this....ill try to keep this problem short: I have a spreadsheet for absence. Our corporate trigger levels where an employee progresses to a stage of absence are 6 days in a row,4 weeks in a row, 3 months in a row and or...
  3. T

    Count records for a date(day) and then average over the number of days

    I have a source School Absences Table for a pivot table. Each row of the table represents one student being absent for a date. So there are many rows for each day. The row contains a unique student id, the school year the student is in and other absence data e.g. term number, week number and...
  4. J

    Conditional formatting for basic attendance tracking

    Hi all, I was wondering if you could help me identify on what formula to use in order for me to count absences for each month and at the same time will accumulate that number. So say, the sheet will count all the absences that the person made and if he/she accumulated more than 3, then the...
  5. C

    Finding sum for last 180 days with a twist

    I have a table that totals absences for the last 18 months. My table includes collapsible rows and headings with a total row for 2017 and 2018. There is also a total row for each month. Because of my layout my column of days is not consistent. I've included an example below: <tbody> A B C D...
  6. S

    Consecutive dates excel

    Hi, Having some problems trying to work out a formula to count incidents of absence. I have a report which gives me a list a column of names and next to it dates they have been absent. I want to work out the incidences of absence, e.g Johan - 01/01/2017, 02/01/2017, 03/01/2017, 10/02/2017 in...
  7. D

    Nested IF statements combined with Tenure Length

    All, I am a Data Reporting Analyst and I could use a little help. I am trying to return results for the following. What I am trying to find is an employee that has been with the company greater than or less than 90 days IF so how many absences in one column return the value based on the absent...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top