Forum Discussion
Jack_Roberts
Dec 09, 2021Copper Contributor
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...
- Dec 10, 2021
What do you see when you open the sample workbook attached below?
HansVogelaar
Dec 10, 2021MVP
What do you see when you open the sample workbook attached below?
Jack_Roberts
Dec 10, 2021Copper Contributor
Hey, that's what I am after thank you. I have copied that formula into my sheet and it works as desired now