Holiday accrual calculations

Hi

In month 1 the employee has accrued 2 days holiday. Also in the month the employee has worked 20 days.

So in my worksheet I have days 1-31, then I have total days worked (which can be added easily), I then have holiday accrued for the month, then holidays taken in the month, then I have total days remaining.

Is there a way of putting 1 for a day worked and 'H' for a days holiday, therefore adding all of the 1's to give days worked but deducting 'H' from holiday days taken?

This is my first post so please forgive me if it has been asked before.

Thanks,

Phil

Hi

Here is what I am trying to do, I hope you understand.

Thanks,

Phil

Hi

I am looking for a formula to put in AL4. Something along the line of =IF B4:AF4=H then sum of H to put in AK4 then subtract this from AJ4.

Is this possible?

I really appreciate your help.

Phil

Great it works, thanks very much.