Borrowing registration form

Borrowing registration formIn order to keep the files well so that they can serve the work safely and effectively, when borrowing files, you must abide by the borrowing system and fill in the borrowing registration form. The free download of the borrowing registration form is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more information about the free downloading of the borrowing registration form, please pay attention to Huajun Software Park.

Introduction to borrowing registration form       Borrowing registration formContent enumeration:      
​​ 1. Click "Insert-Table" on the navigation bar and click "OK"
2. Select the table and click "Horizontal Center" in "Table Tools - Alignment"
3. Enter the header "Borrowing Registration Form" on the form
​​ 4. Line input: date, borrower, reason for borrowing, file type, name of borrowed file, notes, transferred case file, borrower department

General tips for borrowing registration forms

   1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
​ ​ 2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
​​ 4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male", "Female), IF(MOD(MID(C2,17, 1),2)=1,"Male", "Female")) The "C2" in the formula represents the cell where the ID number is entered.

Recommended by the editor of Huajun Software Park