SOLVED

# KEEPING TRACK OF HOLIDAYS IN EXCEL

Occasional Contributor

# 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.

2 Replies
best response confirmed by AlisonAMK (Occasional Contributor)
Solution

# Re: KEEPING TRACK OF HOLIDAYS IN EXCEL

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.

# Re: KEEPING TRACK OF HOLIDAYS IN EXCEL

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

Thank you!!