Forum Discussion
How to count periods of absence in excel
Hey, I am creating a spreadsheet to track holidays and absence. I need to figure out a way of counting periods of absence. For example, in the attachment I want TEST 1 to show as one period of absenc...
What do you see when you open the sample workbook attached below?
Do you mean that the function should count the 3 SH days and 2 S days as one period?
Yes this is what I mean because we record it in two different way but this is the same period.
| Day 1 | Day 2 | Day 3 | Day 4 | Day 5 |
| SH | SH | SH | S | S |
Again, this could also be over weekends
Hope it clarifies.
Thanks. Is S/SH the only combination that should be treated this way, or are there others - if so, please list them in a reply.
- Hans
the combination can be S, SH, U,BH
Thank youSee the attached version.
