Forum Discussion
Solved
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?
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
- Hans
Apologies only just been able to look at it.
It seems to be working in the correct manner so hopefully what you have done has done the trick.
Thanks again for your assistance with this as it will be very useful. Any updates?
Thanks! See the attached version. The function now returns the same values as the ones you indicated.