Umsebenzi we-MONL

Sebenzisa umsebenzi we-MONTH ukususa inyanga ukusuka kumhla ochaziweyo kwi-Excel. Jonga imizekelo emininzi uze ufumane imiyalelo engezantsi ngezantsi.

01 ka 03

Khipha iNyanga ukusuka kuMhla ngeNyanga YOMSEBENZI

Umsebenzi we-MONTH ungasetyenziselwa ukukhupha kwaye ubonise inxalenye yenyanga yosuku olufakelwe kulo msebenzi.

Ukusetyenziswa okuqhelekileyo komsebenzi kukukrazula imihla e-Excel eyenzeka ngonyaka ofanayo njengoko kuboniswe kumqolo 8 womzekelo kumfanekiso ongentla.

02 ka 03

I-Syntax yeeMisebenzi kunye neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi wenyanga:

= INYANGA (I-serili_nani)

I-serial_nomboro - (efunekayo) inombolo emele umhla ophuma ngawo inyanga.

Le nani inokuba:

• inombolo yeenombolo ezimela umhla-umgca 6 kumzekelo;
• ireferensi yeseli kwindawo yokusebenzela yomhla - umgca 4 kumzekelo;
• Umhla wangena njengengxabano yomsebenzi usebenzisa umsebenzi we-DATE-umgca 6 kumzekelo;
• Umhla okhoyo wangena njengengxabano yomsebenzi usebenzisa i-TODAY okanye MANJE imisebenzi - umqolo wesi-7 kumzekelo.

Nerial Numbers

Iintengiso ze-Excel ziba ngamanani alinganayo - okanye iinombolo zee-serial - ukuze zisetyenziswe kwizibalo. Ngosuku ngalunye inani linyuselwa enye. Iintsuku ezikhethekileyo zifakwe njengeengxenyana zemihla - njenge-0.25 kwikota enye yosuku (iiyure ezintandathu) kunye ne-0.5 kwisiqingatha semini (iiyure eziyi-12).

Iinguqulelo zeWindows kwi-Excel, ngokusilelayo:

• NgoJanuwari 1, 1900 = inombolo yenombolo 1;
• NgoJanuwari 1, 2016 = 42370 (kuba iintsuku ezingama-42,370 emva koJanuwari 1, 1900);
• I-12 yintsimbi ngemini ngoJanuwari 1, 2016 ngu 42370.50.

Ukubiza iNyanga yoMzekelo

Imizekelo emfanekisweni apha ngasentla ibonisa iintlobo ezahlukeneyo zokusebenza kwenyanga, kuquka ukudibanisa nomsebenzi we-CHOOSE kwifom ukubuyisela igama lenyanga ukusuka ngomhla okhoyo kwiseli A1.

Indlela osebenza ngayo ifom:

1. Umsebenzi we-MONTH ukhankanya kwinani le nyanga ukususela kumhla kwi-cell A1;
2. ISOOZO umsebenzi ubuyisela igama leenyanga ukusuka kuluhlu lwamagama angeniswe njengeNgxabano yexabiso lelo msebenzi.

Njengoko kuboniswe kwiseli B9, ifom yokugqibela ibonakala njengale:

= UKUHLAWULWA (INYANGA (A1), "Jan", "Feb", "Mar", "ngoMeyi", "NgoMeyi", "ngoJuni", "ngoJulayi", "uAgas", "Sept" "," Dec ")

Ngezantsi zidweliswe amanyathelo asetyenziswa ukufaka ifomu kwifom yeshishini lomsebenzi.

03 ka 03

Ukufaka umsebenzi we-CHOOSE / MONTH

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

1. Ukuthayipha umsebenzi opheleleyo uboniswe ngenhla kwiseli leshidi lomsebenzi;
2. Ukukhetha umsebenzi kunye neengxoxo zayo usebenzisa ibhokisi yencoko yencoko yomsebenzi

Nangona kunokwenzeka ukuba uthayiphe kuphela umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko ejongene nokufaka i-syntax echanekileyo yomsebenzi - njengamaxwebhu okucaphuna azungeze igama leenyanga kunye nabahluli be-comma phakathi kwabo.

Ekubeni umsebenzi we-MONTH udibene ngaphakathi kwe-CHOOSE, ibhokisi yencoko yebhokisi yencoko yentshukumo iyasetyenziswa kwaye i-MONTH ingeniswa njenge- Index_num argument.

Lo mzekelo ubuyisela igama lefom elifutshane ngenyanga. Ukuba nefomula ubuyisele igama elipheleleyo leenyanga - njengeJanuwari kunokuba uJan okanye ngoFebruwari esikhundleni seFebhu, faka igama elipheleleyo leenyanga kwiingxabano zexabiso kulamanyathelo angezantsi.

Amanyathelo okufaka ifom:

1. Cofa kwiseli apho iziphumo zefomula ziza kuboniswa - njengefowuni A9;
2. Cofa kwiThebhu yefomula yemenyu yebhondi ;
3. Khetha uLookup kunye neKhonkco kwi-Ribbon ukuvula uluhlu lwehla lokuhla;
4. Cofa kwiCandelo lokukhupha ibhokisi yencoko yomsebenzi;
5. Kwibhokisi yencoko, nqakraza kwi Index_num line
6. Uhlobo lwe- MONTH (A1) kulo mgca webhokisi yencoko;
7. Cofa kwi- Value1 line kwibhokisi yencoko;
8. Thayipha uJan kulo mgca weJanuwari ;
9. Cofa kwi- Value2 line;
10. Uhlobo lweFeb ;
11. Qhubeka ungena amagama ngenyanga nganye kwimida eyahlukileyo kwibhokisi yencoko;
12. Xa onke amagama enyanga efakiwe, chofoza u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko;
13. Igama likaMeyi kufuneka livele kwiseli yomsebenzi apho ifom efumaneka khona ngoMeyi inyanga ifakwe kwiseli ye-A1 (5/4/2016);
14. Ukuba ucofa kwiseli A9, umsebenzi opheleleyo uvela kwibha yefomula ngaphezulu kwephepha lokusebenzela .