KEEPING TRACK OF HOLIDAYS IN EXCEL

[AlisonAMK]

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

[#2 · Accepted solution]

@AlisonAMK 

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.

[#3]

Thank you so much, I have entered that and it works perfectly.

Thank you!!