Office supplies registration formHow to fill it out?
1. The Personnel Administration Department develops an "Office Supplies Application Form" and submits it to the Personnel Administration Center after confirmation by the heads of each department.
2. The manager of the company's personnel administration center will review, the director of personnel administration will review, and the chairman of the board will approve it and submit it to the assistant of the personnel administration department for unified purchase.
3. When new employees arrive or temporary emergency supplies can be purchased in time based on actual conditions, the Human Resources and Administration Department can reserve some supplies in a timely manner every month.
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
Office supplies registration formIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the office supplies registration form, download it quickly. also,Employee position performance appraisal form,Contract registration ledgerIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works