naughtsncross
New Member
- Joined
- Oct 13, 2017
- Messages
- 4
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 annual entitlement based on their length of service, the dates of the new absence and the number of days to be paid this time. What I now need to do is to add a cell which looks at a list of previous absences and then shows how many paid days the person has received in the 365 days prior to the start date of the current absence.
I have got as far as a formula which pulls back the total number of days paid using the employee number, I am just struggling with limiting it to absences within the last 365 days.
If you are still with me, I will attach a sample of what I am working on (when I can work out how to do this!)
Hope you can help!
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 annual entitlement based on their length of service, the dates of the new absence and the number of days to be paid this time. What I now need to do is to add a cell which looks at a list of previous absences and then shows how many paid days the person has received in the 365 days prior to the start date of the current absence.
I have got as far as a formula which pulls back the total number of days paid using the employee number, I am just struggling with limiting it to absences within the last 365 days.
If you are still with me, I will attach a sample of what I am working on (when I can work out how to do this!)
Hope you can help!
