Employee Attendance Template

Upload the sheet and one of us will take a look if the following does not work. I don't think any VBA is necessary.

Let's say your employees vary with rows and columns have titles in the first row according to the following.
A: Employee
B: YearOfHire
C: TotalDaysDue
D: DaysUsed
E: DaysRemaining
I'll give you a formula to put in column E2 that you can drag down to all employees. I'll assume row 1 has text similar to what I wrote above (of course, you can change B-E as-needed on your particular spreadsheet).

In cell E2: =C2-D2