Umsebenzi we-Excel MONTH

Sebenzisa umsebenzi we-MONTH ukukhipha inyanga kusuka ngosuku olucacisiwe ku-Excel. Bheka izibonelo eziningi bese uthole imiyalelo yesinyathelo ngesinyathelo ngezansi.

01 ka-03

Khipha inyanga kusuka osukwini nosuku lwe-MONTH

Umsebenzi we-MONTH ungasetshenziswa ukukhipha futhi ubonise ingxenye yenyanga yosuku olufakelwe kulo msebenzi.

Ukusetshenziswa okuvamile komsebenzi ukukhipha amadethi ku-Excel okwenzeka ngonyaka ofanayo njengoba kuboniswe kulayini 8 wesibonelo esithombeni esingenhla.

02 ka-03

I-syntax ye-MONTH ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-MONTH yilezi:

= MONTH (inombolo yocingo_yinombolo)

I-serial_nombhalo - (edingekayo) inombolo emele usuku okukhishwa ngalo inyanga.

Le nombolo ingaba:

• inombolo ye-serial emele usuku - irowu 6 kusibonelo;
• ireferensi yeseli endaweni yokusebenzela yosuku - umugqa 4 kusibonelo;
• usuku olufakelwe njengengxabano yomsebenzi usebenzisa umsebenzi we-DATE - irowu 6 kusibonelo;
• usuku lwamanje lufakwe njengengxabano yomsebenzi besebenzisa imisebenzi yanamuhla noma manje - irowu 7 kusibonelo.

Izinombolo ze-serial

Izitolo ze-Excel ziyizinombolo ezilandelanayo - noma izinombolo ze-series - ngakho zingasetshenziswa ekubalweni. Usuku ngalunye inani likhuphuka ngenye. Izinsuku ezithile zifakwe njengezingxenyana zosuku - ezifana no-0.25 ngekota eyodwa yosuku (amahora ayisithupha) no-0.5 ngesigamu sosuku (amahora angu-12).

Ngezinguqulo ze-Windows ze-Excel, ngokuzenzakalelayo:

• NgoJanuwari 1, 1900 = inombolo ye-serial 1;
• NgoJanuwari 1, 2016 = 42370 (njengoba sekuyizinsuku ezingu 42,370 emva kukaJanuwari 1, 1900);
• Ngehora lesishiyagalolunye ekuseni ngoJanuwari 1, 2016 ngu 42370.50.

Ukubiza Isibonelo Senyanga

Izibonelo ezithombeni ezingenhla zibonisa ukusetshenziswa okuhlukahlukene kokusebenza kwe-MONTH, kufaka phakathi ukuhlanganiswa nomsebenzi we-CHOOSE kufomula ukuze ubuyele igama lenyanga kusukela ngosuku olusesitokisini A1.

Indlela okusebenza ngayo ifomu:

1. Umsebenzi we-MONTH ukhipha inombolo yenyanga kusuka ngosuku oluselikhwama A1;
2. Umsebenzi we-CHOOSE ubuyisela igama lezinyanga ohlwini lwamagama angenisiwe njenge-argument Value yalowo msebenzi.

Njengoba kuboniswe esitokisini B9, ifomu lokugcina libukeka kanje:

= CHOOSE (MONTH (A1), "Jan", "Feb", "Mar", "Mar", "May", "Juni", "July", "Aug", "Sept", "Okthoba", "Nov" "," Dec ")

Ngezansi kubalwa izinyathelo ezisetshenziselwa ukungena ifomula kuseli lokusebenzela.

03 ka 03

Ukufaka umsebenzi we-CHOOSE / MONTH

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

1. Ukuthayipha umsebenzi ophelele oboniswe ngenhla kwiseli lokusebenzela;
2. Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lengxoxo ye-CHOOSE

Nakuba kungenzeka nje ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lebhokisi elibheka ukufaka i-syntax efanele yomsebenzi - njengezimpawu zokucaphuna ezizungezile igama lezinyanga zonke kanye nabahlukanisi be-comma phakathi kwabo.

Njengoba umsebenzi we-MONTH uhlelwe ngaphakathi ku-CHOOSE, ibhokisi lokusebenza lomsebenzi we- CHOOSE lisetshenzisiwe futhi i-MONTH ingenwe njenge- Index_num argument.

Lesi sibonelo sibuyisela igama lefomu elifushane ngenyanga ngayinye. Ukuze uthole ifomula ubuyekeze igama lezinyanga ezigcwele - njengoJanuwari kunokuba uJan noma Februwari esikhundleni sikaFebhu , faka igama lezinyanga ezigcwele zezingxabano ze- Value ezinyathelo ezingezansi.

Izinyathelo zokufaka ifomu:

1. Chofoza kuseli lapho imiphumela yefomula izoboniswa khona - njengeseli A9;
2. Chofoza kuthebhu yefomula yemenyu ye- Ribbon ;
3. Khetha ukuLondoloza kanye neNkhombandlela kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza;
4. Chofoza ku- CHOOSE ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi;
5. Ebhokisini lengxoxo, chofoza ku- Index_numugqa
6. Thayipha i- MONTH (A1) kulolu hlangothi lwebhokisi lebhokisi;
7. Chofoza ku- Value1 line ebhokisini lengxoxo;
8. Thayipha uJan kulolu hlangano lweJanuwari ;
9. Chofoza ku- Value2 line;
10. Thayipha uFebhu ;
11. Qhubeka ungena amagama ngenyanga ngayinye emigqeni ehlukene ebhokisini lengxoxo;
12. Uma wonke amagama enyanga efakiwe, chofoza u-Kulungile ukuqedela umsebenzi bese uvale ibhokisi lengxoxo;
13. Igama loMeyi kufanele livele esitokisini lokusebenzela lapho ifomula ikhona kusukela ngoMeyi inyanga ingene esitokisini A1 (5/4/2016);
14. Uma uchofoza ku-cell A9, umsebenzi ophelele uvela kubha yefomula ngaphezulu kwephepha lokusebenzela .