Introduction to borrowing registration form Borrowing registration formContent list:
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 allow the system to 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")) "C2" in the formula represents the cell where the ID number is entered.
Recommended by the editor of Huajun Software Park
Borrowing registration formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Property insurance company business statistics table,Financial accounting organization and personnel status tableDownload to get the source file, which you can edit, modify and replace. To download the borrowing registration form, go to Huajun Software.
it works
it works
it works