Daily Absentee Report

[A11 Mighty]

Hello , I stumbled across this Absentee Report and wanted to make one minor modification if possible.

In TEAM DASHOBOARD Sheet- Would like some suggestions / assistance on how to calculate the "Vacation Left" for the each employee.
I have put together the Vacation Eligibility under "Employees" sheet that calculate how much vacation each employee has based on the years worked.

In EMPLOYEE REPOT Sheet - Similar to the above request, this is a yearly view of each employee where I couldn't figure out how to calculate the Vacation Left.

Attached is a sample file that I hope provide clarity to my request.

Please let me know if any clarification is needed.

Any help is much appreciated!

 

[vletm]

A11 Mighty​

Something like these values?
... I did some minor modifications too.
File Modified.

 

[A11 Mighty]

Hello @vletm,

This is great, one minor clarification/ change if it's possible, the "Half Day" should be part of the calculations for the vacation left.
Thats something I didn't do a good job at clarifying in my initial request and do apologize for it.

In the example of "Employee 3", he had taken a total of 4.5 days of time off. that will leave him 10.5 days remaining

Thank you so much for your assistance.