Help pease

[BiscuitMan4Life]

I’m currently doing a shift planner at work, it’s been a while since I made one, I would like to subtract the holiday from the individuals entitlement. So everytime a “H” is entered it minuses from their annual entitlement. I’m having a complete blank.

Thanks in Advance

 

[MARK858]

On a simple level...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1		01/01/2019	02/01/2019	03/01/2019	04/01/2019	05/01/2019	06/01/2019	07/01/2019		Total holiday entitlement days	Days left
2	Fred		H			H	H			25	22
3	John			H	H					20	18
4	Dave		H	H	H	H	H			22	17
Sheet3

 

[BiscuitMan4Life]

COUNTIF!! Thank you

 

[MARK858]

No problem and welcome to the forum