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?
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
Thanks! See the attached version. The function now returns the same values as the ones you indicated.