Tips for using book inventory reports
Book inventory reportHow to fill it out?
(1) Quantity inventory;
(2) Weight inventory;
(3) Account verification;
(4) Account reconciliation.
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.
Book Inventory ReportIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download a book inventory report, please download it quickly. In addition,financial statements,corporate financial statementsIt is also a good form template. You are welcome to click to download and experience it.





















Useful
Useful
Useful