I would like to figure out a formula in excel where i can track the current vacation time someone has earned to the current date every time I open the file.
The employees have guaranteed 10,15,or 20 days of vacation a year, each person is different, and is based on their start date, but we track all employees on one spread on a calender basis.

Does anyone know what formula i would be able to use?


Employee Vacation Template.xlsx