Class Fee Account SheetPreparation of:
1. It refers to a form that is established according to the prescribed accounting subjects, has a certain format and structure, and is used to classify and continuously record economic business and reflect the increase or decrease in accounting elements and their results.
2. It can be divided into general ledger accounts, detailed ledger accounts, and journals.
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")) "C2" in the formula represents the cell where the ID number is entered.Recommended by the editor of Huajun Software Park
Class fee account form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of class fee account form, please download it quickly.Epidemic prevention duty schedule,Epidemic ThermometerIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works