Forum Discussion
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 following.
Column1 to show initial entitlement of 20 days (excludes bank hols)
Column2 to add all the H's - confirming how many holidays have been taken
Column3 to deduct Col2 from Col1 - to give total remaining
The above would be useful when asked on the spot how many holidays an employee has left.
I have very basic knowledge of excel so you will have to excuse me if I ask if you could explain any suggestions.
Many thanks in advance for your helpful suggestions
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.
2 Replies
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!!
