May 12 2021 07:48 AM
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
May 12 2021 08:06 AM
SolutionLet'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.
May 12 2021 08:11 AM
May 12 2021 08:06 AM
SolutionLet'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.