This is a small Leave system utility. Download the attached zip file and extract excel and access file from it. This can be used in a multi user environment as well by keeping the access database at a commonly accessible location and distributing the excel file to all users. In the access database there is a table 'M_LeaveTypes' from where you can maintain the Leave Type and Max Carry over for each type of leave. In this system an user is identified by his Windows login id.
To get started add a user (by Windows login id of his system). Click New Request on the sheet. Choose Leave Type, enter start date and No. of days. Leave schedule below it will be automatically generated ignoring Bank Holidays.
Your valuable suggestions and feedback are required for further improvement of this Leave system utility.