Forum Discussion
Solved
KEEPING TRACK OF HOLIDAYS IN EXCEL
Hello, Can someone help me please. I would like to keep track of holidays. I have created a calendar and in each week marked H on the day holiday was taken, I would ideally like to do the follo...
Let's say you mark the H's (or not) in H2:NH2
In A2: 20
In B2: =COUNTIF(N2:NH2,"H")
In C2: =A2-B2
Select A2:C2 and fill down as far as needed.
Let's say you mark the H's (or not) in H2:NH2
In A2: 20
In B2: =COUNTIF(N2:NH2,"H")
In C2: =A2-B2
Select A2:C2 and fill down as far as needed.
- Thank you so much, I have entered that and it works perfectly.
Thank you!!
