Skip to main content

How to limit leave days for annual leave

1. Design background

Many users will use YIDA for attendance management, especially leave management. It is necessary to check the annual leave duration of each employee. Please do not exceed the annual leave duration stipulated by the company, however, there is no restriction when taking sick leave or personal leave or other vacation categories.

2. Set steps

2.1 employee annual leave basic data sheet

First, establish a form for the total annual leave duration of employees, and enter the basic data of the total annual leave duration of each employee in each year;

2.2 leave application process sheet

Create a leave process table. In the form, you can return the actual number of annual leave days through the leave category selected by the employee and the review opinion, as shown in the following figure:

Remaining annual leave days:


Use the DAYS function to calculate the number of leave DAYS:

2.3 Data Submission verification

3. Effect demonstration

After all settings are set, the verification formula can be used to prohibit approval of leave applications beyond the annual leave range to avoid incorrect approval by administrators.


YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!

Click here to fill in the questionnaire


-------------------- Get the latest information YIDA, welcome to follow US--------------------

This doc is generated using machine translation. Any discrepancies or differences created in the translation are not binding and have no legal effect for compliance or enforcement purposes.
Copyright © 2024钉钉(中国)信息技术有限公司和/或其关联公司浙ICP备18037475号-4