Gwiritsani ntchito MONTH ntchito kuti muchotse mwezi kuchokera tsiku linalake mu Excel. Onani zitsanzo zambiri ndikupeza malangizo otsogolera pang'onopang'ono.
01 a 03
Chotsani Mwezi Kuchokera Tsiku ndi Ntchito YANGA
Ntchito ya MONTH ingagwiritsidwe ntchito kuchotsa ndikuwonetsa gawo la mwezi wa tsiku limene lalowetsedwera.
Ntchito imodzi yomwe amagwiritsidwa ntchito pa ntchitoyi ndi kuchotsa masiku omwe ali mu Excel omwe amachitika chaka chomwecho monga momwe tawonetsera mzere 8 wa chitsanzo pa chithunzi pamwambapa.
02 a 03
Syntax ndi Zokambirana za Mwezi
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha MONTH ntchito ndi:
= MONTH
Zowonjezera_kuwerengera - (zofunikira) chiwerengero choimira tsiku limene mweziwu umachokera.
Nambala iyi ikhoza kukhala:
- nambala yotsindikiza yoimira tsiku - mzere 6 mu chitsanzo;
- selo loyang'ana pa tsamba la ntchito pa tsamba - mzere 4 mu chitsanzo;
- Tsiku limalowa monga ndondomeko ya ntchito pogwiritsa ntchito DATE ntchito - mzere 6 mu chitsanzo;
- Tsiku lachidziwitso linalowa monga ndondomeko ya ntchito pogwiritsa ntchito MASIKU ano kapena MASIKU ano ntchito - mzere 7 mu chitsanzo.
Numeri Zakale
Masitolo a Excel amakhala ngati manambala owerengeka - kapena manambala amodzi - kotero angagwiritsidwe ntchito powerengera. Tsiku lililonse chiwerengero chikuwonjezeka ndi chimodzi. Masiku osankhidwa amalowa ngati magawo a magawo a tsiku - monga 0.25 kwa kotala la tsiku (maola sikisi) ndi 0,5 kwa theka la tsiku (maola 12).
Kwa Windows mawonekedwe a Excel, mwachinsinsi:
- January 1, 1900 = nambala nambala 1;
- January 1, 2016 = 42370 (popeza ndi masiku 42,370 pambuyo pa January 1, 1900);
- 12 koloko masana pa 1 January, 2016 ndi 42370.50.
Kutchula Mwezi Chitsanzo
Zitsanzo zomwe zili pamwambapa zikuwonetsera ntchito zosiyanasiyana ku MONTH ntchito, kuphatikizapo kuphatikiza ndi ntchito YOPHUNZIRA mwa njira yoti abwererenso dzina la mwezi kuyambira tsiku lomwe lili mu selo A1.
Momwe ntchitoyi ikugwirira ntchito ndi:
- Ntchito ya MONTH imachotsa chiwerengero cha mweziwo kuyambira tsikulo mu selo A1;
- CHOOSE ntchito imabweretsanso dzina la mwezi kuchokera mndandanda wa mayina omwe alowe ngati ndondomeko yamtengo wapatali.
Monga momwe tawonetsera mu selo B9, mawonekedwe omalizira amawoneka ngati awa:
CHOOSE (MONTH (A1), "Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sept", "Oct", "Nov "," Dec ")
M'munsimu muli ndondomeko zomwe zimagwiritsidwa ntchito kulowa mndandanda mu selo lamasewera.
03 a 03
Kulowa Ntchito YOPOSA / MWEZI
Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:
- Kujambula ntchito yowonetsedwa pamwambapa mu selo lamasewera;
- Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito CHOOSE ntchito dialog box
Ngakhale kuti n'zotheka kungolemba ntchito yonseyo pamanja, anthu ambiri amavutika kuti agwiritse ntchito bokosi la bokosi lomwe likuyang'anitsitsa kulowa mu syntax yolondola ya ntchito - monga zizindikiro zomwe zimatchulidwa mwezi uliwonse ndi dzina losiyanitsa pakati pawo.
Popeza kuti MONTH ntchito imakhala mkati mwa CHOOSE, CHOOSE ntchito yogwiritsira ntchitobox ikugwiritsidwa ntchito ndipo MONTH imalowa monga Index_num argument.
Chitsanzo ichi chibwezeretsa dzina lalifupi la fomu mwezi uliwonse. Kuti mubwezere mayankho pamwezi wathunthu - monga Januwale osati Jan kapena February m'malo mwa Feb, lowetsani dzina la mwezi wathunthu kuti mukhale ndi zifukwa zamtengo wapatali m'magulu otsatirawa.
Ndondomeko zolowera mndandanda ndi:
- Dinani mu selo momwe zotsatira zazotsatira ziwonetsedwe - monga selo A9;
- Dinani pa Fomu tab ya menyu yowonongeka;
- Sankhani Kujambula ndi Kutchulidwa kuchokera ku Riboni kuti mutsegule ntchito yolemba pansi;
- Dinani pa CHISANKHO mu mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
- Mu bokosi la bokosi, dinani pa Index_num line
- Lembani MONTH (A1) pamzerewu wa bokosi la dialog;
- Dinani pa Value1 mzere mu bokosi la dialog;
- Lembani Jan pamzerewu kwa Januwale ;
- Dinani pa Value2 mzere;
- Fuzani Feb ;
- Pitirizani kulowetsa maina mwezi uliwonse pa mizere yosiyana mu dialog box;
- Pamene maina onse a mwezi amalowa, dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la dialog;
- Dzina la May liyenera kuwonetsedwa mu selo lamasewera limene ntchitoyi ilipo kuyambira May ndi mwezi kulowa mu selo A1 (5/4/2016);
- Ngati inu mutsegula pa selo A9, ntchito yonseyo ikuwoneka mu bar barula pamwamba pa tsamba .