Excel MONTH Basa

Shandisa MONTH basa kubvisa mwedzi kubva pane imwe nguva yakatarwa muExcel. Ona mienzaniso yakawanda uye tora danho-nhanho mirairo iri pasi apa.

01 of 03

Bvisa Mwedzi kubva kune Zuva neChina CHIMO

Basa reMWECH rinogona kushandiswa kubvisa uye kuratidza mwedzi chikamu chezuva rakapinda mubasa racho.

Kumwe kushandiswa kwevakawanda kwebasa ndokubvisa mazuva muExcel anowanikwa mugore rimwechete sezvakaratidzwa mumutsara 8 wemuenzaniso mumufananidzo wepamusoro.

02 of 03

Syntax Mushandi uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara weMUNTI basa ndewokuti:

= MUNDI (Serial_number)

Serial_number - (inoda) nhamba inomiririra zuva rinobva mwedzi wacho.

Nhamba iyi inogona kuva:

• nhamba ye serial inomiririra zuva-mutsara 6 mune muenzaniso;
• sero rinoreva nzvimbo yekushandura yezuva - mutsara 4 mumuenzaniso;
• zuva rakapinda senyaya yebasa uchishandisa DATE basa - mutsara 6 mune muenzaniso;
• zuva ranhasi rakapinda senyaya yebasa uchishandisa MAZUVA ano kana ZVINO zvinoita - mutsara 7 mune muenzaniso.

Serial Numbers

Zvinyorwa zveExcel dzinotarisa sezviverengero zvakaenzana - kana nhamba dze serial - saka dzinogona kushandiswa mukuverenga. Zuva roga roga nhamba inowedzera neyese. Mazuva mashoma anopinda sezvikamu zvezuva - zvakadai se 0.25 kwekota yezuva (maawa matanhatu) uye 0.5 kwehafu yenguva (maawa 12).

For Windows versions of Excel, by default:

• January 1, 1900 = serial nhamba 1;
• January 1, 2016 = 42370 (sezvo iri mazuva 42.370 mushure meJanuary 1, 1900);
• 12 o'clock masikati paJanuary 1, 2016 pane 42370.50.

Kutumidza Mwedzi Muenzaniso

Mienzaniso iri mumufananidzo wepamusoro inoratidza kushandiswa kwakasiyana-siyana kweMUMWE basa, kusanganisira kuibatanidza neCOOSE basa mune imwe nzira yekudzorera zita remwedzi kubva pazuva raive muchitokisi A1.

Nzira iyo inoshandiswa nayo ndeyekuti:

1. Basa reMWECH rinotora nhamba yemwedzi kubva pazuva iri muchitokisi A1;
2. ICHOOSE basa rinodzorera zita remwedzi kubva pane mazita emazita akapinda seChirungu chekukosha chebasa iroro.

Sezvinoratidzwa muchitokisi B9, chimiro chekupedzisira chinoratidzika seizvi:

CHOOSE (MUMWE (A1), "Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sept", "Oct", "Nov "," Dec ")

Pasi apa yakatorwa matanho anoshandiswa kupinda mufomu mumusero webasa.

03 of 03

Kupinda CHOOSE / MUMWE Basa

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana rinoratidzwa pamusoro apa mumusero webasa;
2. Kusarudza basa uye mazano aro uchishandisa CHOOSE basa dialog box

Kunyange zvazvo zvichikwanisika kungonyora basa rakakwana mumunhu, vanhu vazhinji vanoona zviri nyore kushandisa bhokisi rebhokisi rinotarisa kupinda muchirevo chakarurama chebasa - zvakadai semashoko ekudzokorora akakomberedza mwedzi wega wega zita uye vatengesi vemazana pakati pavo.

Sezvo MUMWE basa rakagara mukati meCOOSE, CHOOSE basa dialog box inoshandiswa uye MONTH inopinda se Index_num argument.

Uyu muenzaniso unodzorera zita romufomu pfupi pamwedzi mumwe nomumwe. Kuti uve nechirongwa chekudzorera mwedzi wakakwana zita-yakadai saJanuary pane Jan kana February kunze kweFeb, pinda muzita rose remwedzi weZvinokosha mazano mumatanho ari pasi apa.

Masitepisi ekupinda mumuyo ndiwo:

1. Dzvanya pane sero iyo migumisiro yemigumisiro ichave yakaratidzwa - yakadai sesero A9;
2. Dzvanya paMafomu tab yebhoni yebhoni ;
3. Sarudza Kuona uye Kutarisa kubva kubhoni kuti uzarure basa rinoderedza pasi;
4. Dzvanya pa CHOOSE murugwaro kuti ubudise bhokisi rebasa rebasa;
5. Mubhokisi rebhokisi, tora pane Index_numurongo
6. Tora MONTH (A1) pamutsara webhokisi rebhokisi;
7. Dzvanya paIncamiso1 mutsara mubhokisi rebhokisi;
8. Tora Jan pamutsara uyu weJanuary ;
9. Dzvanya paIri Value2 line;
10. Tanga Feb ;
11. Ramba uchipinda mazita mumwedzi wega woga pamiganhu yakasiyana mubhokisi rebhokisi;
12. Kana mazita emwedzi ose apinda, tora OK kuti upedze basa uye uvhare bhokisi rebhokisi;
13. Zita rokuti May rinofanira kuonekwa mumusero webasa rekushanda iyo maitiro aripo kubva muna May mwedzi wakapinda muchitokisi A1 (5/4/2016);
14. Kana iwe ukatora pane cell A9, basa rakakwana rinowanikwa mubhairi yepamusoro pane pepa pepaji .