Tips for using weekly work plan template
PlanningThings to note:
1. Generally, it must include the name, number, date of preparation, preparation department or preparer, reviewer, approver, etc.
2. Each company’s forms have its own fixed format, and the forms between various departments of the company are closely related in both content and form.
3. When designing a specific work plan form, you must consider the interface with other forms and coordinate with other forms to form a comprehensive, systematic work plan form structure that can meet the requirements of enterprise management
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
Weekly work schedule templateIt 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 weekly work plan template, download it quickly. also,Civil Service Examination Score Sheet,vehicle insurance statistics tableIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works