absences

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...

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...

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...

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...

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...

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...

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...