If you are looking for software to use, go to Huajun Software Park! software release

Hello, if there is a need for software inclusion, please package the software and attach the software name, software introduction, software-related screenshots, software icon, soft copy, and business license (if you do not have a business license, please provide the front and back of the corresponding developer ID card) and a photo of yourself holding your ID card) and send it to your email http://softwaredownload4.com/sbdm/user/login

Close >>

Send to email:news@onlinedown.net

Close >>

Location: front pageTable sampleform templateTeaching form Company employee roster
Company employee roster

Company employee roster free version

QR code
  • Software licensing: shareware
  • Software size: 0.01MB
  • Software rating:
  • Software type: Domestic software
  • Update time: 2024-10-31
  • Application platform: WinAll
  • Software language: Simplified Chinese
  • Version: Free version

Software introduction Related topics FAQ Download address

Basic introduction
Company employee roster section first LOGO
Company employee rosterIt is a written material produced by the employer to record the basic situation of the employees of the unit and the operation of labor relations. This is a set of company employee roster forms for download that have been carefully screened by Huajun Software Park. The template format is XLSX. After downloading company employee roster Excel for free through Huajun Software Park, you can change the content and style of the template by yourself!

Screenshot of company employee roster

Tips for using company employee roster

​​​Company employee rosterPreparation of:

​​​​First, the basic information of the worker, including the worker’s name, gender, citizen ID number, household registration address and current address;
The second is the form of employment, including full-time employment, part-time employment, labor dispatch, etc.;
The third is the starting time of labor, that is, the time when workers actually provide labor.
The fourth is the term of the labor contract, including fixed term, no fixed term or a term based on the completion of certain work tasks.

General tips for company employee rosters

​ ​ 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

The company employee roster is a very practical form, and most of the forms are for general purposes. If you happen to need to download the company employee roster Excel form, download it quickly.Interviewer information registration form,Registration form for cancellation of leaveIt is also a good form. Welcome to click to download and experience it!

FAQ

Company employee roster

Company employee roster free version

closure