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

A formula that gives the Days Due is:

Please Login or Register  to view this content.

Here is a copy of your file with the formula applied: Copy of EmployeeAttendanceTest.xlsx
Let me know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. To change the date range select one of the cells in the drop down then from the data tab select data validation > yes > the settings tab. In the source box you can see the years that you are presently able to select. Delete the ones that you don't need and add the ones that you do. Let me know if you have any questions. Hope that you have a good day.