# Complicated task

1 Reputation point
2022-05-23T14:24:02.55+00:00

Hi everyone,

I have one spreadsheet.

I am looking for the remaining entitlement for sickness by pulling data of how many days/hours have been already used.

Could anyone help?

It is a very complex question.

H2 = Start date of the employee
I2 = Start date of the absence
J2 = End date of the absence
L2 = days/hours of the absence, but there are multiply lines of sickness (e.g. 1 employee can have 3 lines so they are in L2,L3 and L4)

There is no cell for the total used - I think I need that

R2 = month in service as employees have different entitlement, depends on how many month they are working with us.
S2 = Sickness allowance in days
T2 = Sickness allowance in hours

How do i get the remaining sickness entitlement of we have these criterias:

• The employee's sickness allowance renewing every year from the start date
• The first 3 days of sickness is not paid

please see table for the allowances:

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,693 questions
{count} votes

## 3 answers

1. 1 Reputation point
2022-05-24T09:00:10.9+00:00

When they are sick, weekends counts in as well, yes

Thank you for looking :)

Kind regards
Tunde

2. 1 Reputation point
2022-05-27T09:40:11.82+00:00

Can i somehow send the excel spreadsheet to you?

On here, it doesn't let me, it says it cannot be .xlsx
When i convert it to .XML, my file is 10,000 KB

Kind regards
Tunde

3. 1 Reputation point
2022-05-27T09:57:22.03+00:00