Hi all,

I am attempting to make a dynamic employee tracker for attendance. I have attached a sample workbook.

The workbook has: Employee Name, Vacation Used, Sick Days Used and Care Days used on the first sheet to summarize the info. The second sheet has the input data. Employee Name, Attendance Type, Start Date and End Date. I used data validation and named ranges to have drop downs for the first two columns.



Essentially, I am having issues with finding a formula to calculate the dates for each Employee correlated to the Attendance Type.

I have tried a number of combinations using Countifs, sumproduct, Index, If, Index Match, etc.

The formula I am attempting to find is dynamic as it is meant to include any new entries.

Any help would be greatly appreciated.

Attached Files

Tracker.xlsx (9.3 KB, 20 views)