Forum Discussion
Solved
Count sick leave times
Dear Team, I am currently working on a HR report and I would like to have you help on this issue to caculate the sick leave freqency rate. I have the table of Employee sick leave with start d...
Vanivanivani , refer ot my blog on similar topic , see if that can help
amitchandak
Super User
Super UserVanivanivani , refer ot my blog on similar topic , see if that can help
Hi there,
Thanks for the solution. May I just add one more question related?
How to count in the weekends?
For example,
| Employee ID | Sick leave Start date | Sick leave End date |
| 123 | July 05 2021 | July 09 2021 |
| 123 | July 12 2021 | July 16 2021 |
Actually July 10 and 11 are weekend, so for this employee, his/her sick leave time is once.
Could you please kindly help to sort out this matter?
Thank you in adavance