The role of home improvement budget:
1. It is the basis for budget preparation and settlement;
2. It is the basis for preparing unit valuation tables;
3. It is the basis for calculating project budget costs and preparing construction project budget quotas and budget indicators.
4. It is the basis for construction units to evaluate labor productivity and conduct economic accounting.
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
Home improvement budget quotation form templateIt is a very practical form, and most of the forms are for general purposes. If you happen to need a home improvement budget quotation form template, come and download it. also,Personnel Health Registration Form,Interview sign-in formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works