employee holidays remaining excel

[topmayra]

i use this free calendar trumpexcel.com/excel-leave-tracker/

i want help how to check my employee remaining holidays by year (red cell on calendar) if max holidays = 48 per year...

holidays symbol = V

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post