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?
Dagmara912
Copper Contributor
HansVogelaar this is genius, thank you. How can I make the formula not to be case sensitive?
HansVogelaar
Mar 03, 2023MVP
Change the line
If coderange(i).Value = code Then
to
If UCase(coderange(i).Value) = UCase(code) Then
- Dagmara912Mar 03, 2023Copper ContributorThank you so much