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