1. M

    Calculate absences within a period

    Hello I'm hoping you can help if possible please. I have a spreadsheet with 3 tabs, on tab 1 is the formulas / calculations, tab 2 holds all the data and tab 3 has dates (start/end date). I am trying to calculate how many occasions of absence an employee has within a 6 month period and...
  2. Chris_010101

    Excel (Formula/VBA) Help: Two sheets into one

    Hello, I have an absence tracker which records absence in a current 6-month rolling period and a previous 6-month rolling period. Each occasion of absence is recorded as a separate row and absence is manually added to the "current 6 month" sheet daily (as it occurs). A piece of VBA code then...
  3. Chris_010101

    VBA Code Help

    Hello, I use the below code for my absence tracker which was kindly provided on here. I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at: Current 6 months Tab - All absence in the last 6 month rolling period from...
  4. J

    Determination of the absence rate

    Hello everybody, I am currently trying to determine from the data model, how high the absence rate for the individual weeks or months. So far, I've just added the factor to the pivot calendar, whether it's a workday. The table with the presence or absence of the employees is structured as...
  5. Z

    Help with Index/Match/If/Or

    Hi Guys. Hoping someone can help me with this, I can’t seem to figure it out. Table Absence: Employee ID Date Reason Table RTW: Employee ID Absence start date Absence end date RTW completed date (There is other data, not relevant) If looking to match the absence to the RTW. Each absence...
  6. D

    MIN Formula

    So i need to extract time from a 2 cells, clash against a date and return a sum so Column D = Name D2 = John Smith Column E = Shift Total Hours E2 = 08:00 Column F= Shift Date F2 = 06/01/2019 F3 = 07/01/2019 Column I = Name I2 = John Smith Column J = Absence Start J2=01/01/2019 08:00 Column K =...
  7. 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...
  8. J

    how to count occurances of a number being larger than a previous number within a specific time period (rolling 3 months)

    Hi Everyone, this is my first post I have found some great solutions on this site over the last few months but I can find how to do what I am looking for and was hoping someone could help me I run a spread sheet to track absence days at work and need help with how to count specific absence...
  9. J

    Creating an OutPut from a Set of Data (VBA?)

    Hi Hoping someone can help me :) I have a workbook that consists of two tabs. I have From a "calendar" that records employee absence through Sickness (S) or Industrial Sickness (I) We are finally going into the modern ages and will be recording this in a T&A system in the future. However, I...
  10. C

    counting consecutive days worked.....

    Trying to count employee's consecutive days worked (no more than 13, 14th has to be a rest day). Problem is.. count should restart after an absence. 8/1 8/2 8/3 8/4 8/6 8/7 8/8 Consecutive Days Worked In In In In In In In 1 1 1 0 1 1 1 1 1 0 1 0 1 1 0 0 0 0 0 0 0 1...
  11. T

    This has beaten me. Can you help?

    I have tried for hours but cant figure it out. im hoping you can help. I have two spreadsheets. Spreadsheet 1 (SS1) that tells me a list of employee absence. column A has employee number and B has absence start date. The same employee may appear more than once if they have had more than one...
  12. D

    Absence Sheet

    Needing assistance with creating my absence sheet. I am needing the dropdown/type cells and hours cells to calculate into other columns. Row A = Type with dropdown for types of absences vaca/sick/military Row B = # hours absence Row C = Sum of hours of certain type from dropdown...
  13. A

    Trying to Create a Macro to Autoformat a Report

    Hi All, I am fairly new to VBA coding however a lot of people at my work rely on me to create useful macros for our office. One of the reports that we pull from our employee portal is absolutely atrocious and I have been tasked with formatting it correctly. So to give you an idea of the data...
  14. I

    Sort Method of Range Class Failed

    Hi all First off just want to say what a great helpful community you have here. I hardly ever post questions mostly because I don't need to due to the help you have given out in the past but this time I am stumped on something. The kind of problem I'm about to describe is something I...
  15. 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...
  16. N

    Formula for counting occurrences by individual within a rolling year period

    Good Afternoon! I am hoping that someone out there may be able to help me with a hurdle I have reached. In a (large) nutshell, I am trying to design an absence spreadsheet to be used to calculate whether someone is entitled to receive sick pay. I have the spreadsheet calculating a person's...
  17. C

    Absence Tracker

    Hi all, I'm trying to develop a absence tracker; I managed to cover most of the requirement apart from one that I need your help with. Workbook contains dates in row 12 and each individual absence is recorded in rows below as 1, 0.5 (day) etc. We are measuring absence on rolling 12 months basic...
  18. L

    counting absences conditionally, based on whether or not consecutive

    I recently asked about counting "occurrences" and "half-occurrences" in an absence calendar. The premise is that row 1 contains a value indicating an absence (UP = unplanned, T = Tardy, LE - Leave Early) If the absence is .25 of an hour up to 2 hours, it's half an occurrence, if it's 2 hours or...
  19. S

    VBA 10th Line of data to Another Sheet

    Good afternoon, I have a sample data set below.I have over 500,000 records. Each child can have from 1 to 182 days absent (1 to 182 lines of data). What I need to do is to have VBA list on Sheet2 every 10th school or 10th line per Id number and if the child does not have 10 absences then bring...
  20. V

    Absence Tracker

    I have created an absence tracker that tracks points accured on a rolling 12 month system. If an employee takes an unexcused absence he gets a point. After 12 months, a point will be taken back. I believe I have completed this with this formula in I5...

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