Calculate number of leave days per employee per month
I am working on two sheets: Employee Entitlements and Leave Register.
Sheet 1: Leave Application, where all the employees submit their PTOs.
Sheet 2: Summary sheet, holds the summary of each employees' leave balance, days used, and leaves incurred per month.
How do I calculate the number of leave days per employee per month? Also how will it work if the leave application spills over to the next month?
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!