Forum Discussion
Re: How to count periods of absence in excel
Apparently, you want something else than Jack_Roberts who started this discussion. They wanted to count periods as if weekend days didn't exist. For example, if an employee is sick on:
Thu 9 Nov, Fri 10 Nov, Mon 13 Nov and Tue 14 Nov, it should count as 1 period since Sat 11 Nov and Sun 12 Nov should be ignored.
Can you explain what you want?
6 Replies
- Hans
Apologies. You are correct as i did not pay attention to the days in the column. The statement is correct in terms of ignoring the weekends.
Did you have a look at the file i attached previously as i do not seem to get the right outcome.
Thanks again for your help.Is this better? Please check carefully.
Hans
Thank you for your help so far.
I have been through it and some period count do not seem to be correct. Please see on the attached the manual check in red.
Really unsure as to the reason why as this goes beyond my knowledge and understanding!!!
Would appreciate if you have time to have a look.
Thanks again
