sick

I want to find what person is most likely to have infected my salesman. I have two tables, one of sick salesmen and their customers and the well salesmen and their customers. The customers overlap. I want to find the most common customers that might have made them sick by subtracting out the...

Hello! I'm new to the website, but have found many great answer here also. I am hoping someone might be able to provide me with some insight. I have been creating an excel spreadsheet for a client to track used sick and vacation days. At the end of the year, they carry over any unused sick...

I have a lot of data which shows what dates staff have been sick.. a bit like what is below: I want to be able to get Excel to recognise where a sickness for an employee is greater than 14 days on the data below. I was thinking IF(AND(something something something),"LTS","STS)... but I can't...

Hey I'm trying to set up a spreadsheet which will let me track sickness for members of staff over a rolling 12 month period. So far I have: First day of sickness, Last Day of Sickness, Number of Days I would like to add a column that gives me the total number of days over the last 12 months...

Hi All, this is my first ever posting so hope this is all correct (apologies if it is not please let me know what to do next time if I am incorrect) I am trying to do a spreadsheet which counts sick leave/annual leave etc so far it is all easy but I decided to take it up a notch and got stuck...