# sick

1. ### Case sensitive sumproduct

Hello, I have a problem with a formula in a staff holiday tracker. The tracker has the employees names in Coloumn A, from row 6 to row 15. Coloumns B-NI correspond to the days of the year: each employee enters the leave codes, as per the table below: <tbody> Leave Name Code Sick Leave S...
2. ### Sick Leave

Good Day. Please help with the necessary formula. My employee gets 36 days sick leave over 36 months of work. But for the first 6 months he only get 1 day for every 26 days worked. on day 1 of the 7th month the rest of the 36 days "kick in"and needs to be added to the rest. HELP ! ...
3. ### Sick Leave Accrued Formula?

Hello everyone. I work in a trade school have been asked to calculate is sick leave accrual for the staff. The company pays employees biweekly (40 hours each week, 80 biweekly, 8 hours a day. There is no limit to sick days carried over. I only need to show sick time accrued. I would like to be...
4. ### Assigning Values to Text

Hello, I am trying to assign values to text in multiple cells. I am trying to make an employee attendance tracker less manual. For example when I fill a cell that represents a day on a calendar I would use the word "sick" when they call out. How do I make that word "sick" equal to a value of 8...
5. ### Formula to first find and then sum

I have a workbook with tabs 1 - 31 representing the days of the month. On each sheet we have employees name, ID, start time, date, and Comments. I currently have a Summary sheet that pulls over the ID and Comment, if any. What I now need is something to total, if a person (ID) has a comment...
6. ### Sickness Occasions excluding weekends

Im having trouble trying to exclude the weekdends from my sickness occasions formula {=SUM(IF(FREQUENCY(IF(B1:B365>=(A1-365),IF(D1:D365="Sick",ROW(D1:D365))),IF(B1:B365>=(A1-365),IF(D1:D365<>"Sick",ROW(D1:D365)))),1))} Sick database looks like Date 01/01/19 Sick 02/01/19...
7. ### adding more coloums to sum if

=SUMIF(table[[#All],[Date]],"="&B4,table[[#All],[CRG HRS]]) i now need to add the following which is right next to each other. (this is a pivital table <tbody> CRG HRS Sick Annual PPH </tbody>
8. ### To find out the missed date

Hi I have two reports to check the attendance, one is attendance tracker which we update manuualy in excel. In coloumns headings are names, dates (for example, column A has name, b has 1st march, c has 2nd march and so on.) row waise it has absent, priveledge leave or sick leave. Report 1...
9. ### Counting Cells based on separate column with Index/Match

I have a table that has group/division names, employee names, and then tracking an attendance measure for multiple days throughout the year. I'm trying to create a table at the top so that division leads can type in the day and see how many people they had check in that day. Checkins start...
10. ### If Sumproduct Help

Hello, I am attempting to build a formula that displays the status of employees on a calendar. I am trying to get the "Value If True" portion of the formula to change based on the status selected. So, if Vacation is selected, then "Vac" is displayed. If "Sick" is selected, then "Vac" changes...

Hi All I am hoping you can help me. I have to produce a holiday calender/sick calender for staff of 28. They can book half day am, halfday pm, full day, and there is sick am, sick pm, sick full day. so against each date i will enter HAM or HPM or HFD, same with the sick row SAM, SPM, SFD. I...
12. ### Percentage comparison between 2 cells

Hi Guys n Girls I am tracking Sick and Overtime in a financial year spreadsheet which is working well in showing the top hours for different staff. I would like if possible to show a percentage comparison with the 2 columns with the Sick and Overtime data in it and with that highlight the staffs...
13. ### Sick leave accrual

Hello. I need assistance building a simple spreadsheet to track sick leave that has a 1 hour for every 40 worked accrual rate. This needs to be a rolling balance set-up so if a PT employee works 25 hours one week and 30 the next, the accrual will be triggered by the 40 hour mark and start the...

I'm currently trying to create a formula that will allow me to enter in sick days for employees. I'm a little bit stuck with it though at the moment, and could really use a hand.. Basically, Every month an employee "earns" one sick day, up to a maximum of 60. At the beginning of the year, I'd...
15. ### government sick leave calc/formula

Hello! It's been awhile..... I am looking for formulas to figure out months & days from sick leave accumulated to count toward retirement. At retirement age, providing I'm not ever sick between now & then, I will have 1342 hours of accumulated sick leave. Anything over a year (2087 hours) is...
16. ### Attendance Tracking for Rolling 12 months

karmarjoy 07:38 AM Today I'm sure this has been asked but I have to have this done today for a job interview. Yes, on a Saturday. LOL. So, the assignment is a spreadsheet to track sick days taken. Each sick day taken falls off after 12 months. I've got the workbook (by Year and by month) done...
17. ### Split Dates formula

Hi I have attached a document with 2 sheets Sheet 1 has no formulas and is purely data that shows sick time between 2 dates there are multiple entries per cost centre, I have highlighted in yellow on sheet one the days it should return. Sheet 2 - currently in E4 I have a formula that...
18. ### Accrued Sick Pay

Listed below is a dummy spreadsheet. I am trying how to get column E not to exceed 24 hours and row 27 column C (total accrued sick time) not to exceed 48. The formula is regular hours/30=accrued sick time. You cannot accrue more than 48 and cannot use more than 24 available hours per calendar...
19. ### Excel timesheet - netting sick, vacation, with extra time worked

Hi, I like many other do not pay OT until a person actually works 40 hours. So if a person works 10 hours on Monday (2 hours of OT) but takes 2 hours of sick time on Tuesday. I want my spreadsheet to Net the sick time on Tuesday against the two hours extra time worked on Monday. I think...

Our company has 15 sick days a year of these days 3 can be used as personal. The following formula I have used to figure sick/personal days left for the year starting in February 2013. B75=+Jan.2013!B75 totals sick days remianing for year-(AJ75 total sick days used for the month)-(AJ76 total...

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

### Which adblocker are you using?

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

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