Kelli Webb
Member
Hello,
I am trying to establish if someone has been absent for the full calendar month i.e. 1/4/2021  30/4/2021 based on numerous leave records.
Column J  I figured out the formula for those who were on leave prior & post April. My issue is for those employees who have broken leave in the month.
Column I  Is the max days they work per month that falls between 1/4/2021  30/4/2021 factoring in Parttime employees.
Column K  The presumption is if their total leave exceeds the figure in column I, they would be deemed as Yes for extended leave.
If you have any questions please don't hesitate to contact me.
Take care, Kelli
I am trying to establish if someone has been absent for the full calendar month i.e. 1/4/2021  30/4/2021 based on numerous leave records.
Column J  I figured out the formula for those who were on leave prior & post April. My issue is for those employees who have broken leave in the month.
Column I  Is the max days they work per month that falls between 1/4/2021  30/4/2021 factoring in Parttime employees.
Column K  The presumption is if their total leave exceeds the figure in column I, they would be deemed as Yes for extended leave.
If you have any questions please don't hesitate to contact me.
Take care, Kelli
Attachments

28.4 KB Views: 15