Shandisa Excel EOMONTH Basa rekuwedzera / Kubvisa Mwedzi kusvika Mazuva

01 ye 01

Tora zuva rakatarwa kana kuti zuva rekutanga neEOMONTH Basa

IEOMONTH inoshanda, iri pfupi nokuda kweKuguma kweMwedzi basa, inogona kushandiswa kuverenga zuva rekukura kana zuva rakakodzera rekutsvaga kana purojekiti inowira pakuguma kwemwedzi.

Kunyanya zvakanyanya, basa rinodzorera nhamba ye serial yezuva rokupedzisira remwedzi pamusoro pehamba inoratidzwa yemwedzi isati yasvika kana kuti mushure mokutangira musi wekutanga.

Basa racho rakafanana zvikuru neEEDATE basa , kunze kwekuti DATE dzekudzoka dzemazuva ari nhamba chaiyo yemwedzi zvisati zvaitika kana mushure mekutanga kwekutanga, EOMONTH nguva dzose anowedzera maawa akakwana kusvika pakuguma kwemwedzi.

EOONONTH Basa reStain neArguments

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

Mutsara weEOMONTH basa nderokuti:

= EOMONTH (Start_date, Mwedzi)

Start_date - (inoda) zuva rokutanga reprojekti kana nguva inobvunzwa

• iyi nharo inogona kunge iri zuva rakapinda mubasa racho, kana kuti zita rakarongerwa kana kuti sero rinotarisa kune nzvimbo yedhesi mubasa rekushanda.
• kana imwe sero inopinda nokuda kwekutanga kwemazuva inotarisa kune rimwe risina chinhu, basa rinoona sero kuti ive nhamba yema serial ye zero uye inotara zuva rekupedzisira kuva mwedzi yakawanda mushure mezuva rekunyengera January 0, 1900 - sezvakaratidzwa mu mutsara 9 wemuenzaniso.

Mwedzi - (inotarisirwa) nhamba yemwedzi mushure mokunge kana mushure mokutanga_date

• iyi nharo inogona kuva zuva rakapinda mubasa kana zita rakanzi zita kana sero rinotarisa kune nzvimbo yedhesi mubasa rekushanda;
• maitiro akanaka anopa nguva yemberi - mutsara 8 mumufananidzo uri pamusoro;
• Maitiro asina kunaka mazuva adarika - mutsara wechitatu mumufananidzo uri pamusoro;

• Kana mwedzi isiri kureba, iyo inotorwa (chikamu chechidimbu chakabviswa) - sezvinoratidzwa mumutsara we8 mumufananidzo pamusoro apa apo makore 12.25 akatarirwa kune integer 12;

Error Value Returns

Basa rinodzoka #VALUE! kukanganisa kunokosha kana:

• Start_date haisi zuva rakakodzera - sezvinoratidzwa mumutsara wechina mumufananidzo wepamusoro, kubva musi wa2/30/2016 (February 30, 2016) zuva risina kubvumirwa;
• sero rekushandisa rinoshandiswa kweMwedzi kupikisa pfungwa kune imwe sero ine maBoolean maitiro , nhamba yemashoko, kana maitiro ekukanganisa .

Basa rinodzorera #NUM! kukanganisa kunokosha kana:

• Start_date isati yaJanuary 1, 1900;
• Start_date minus Mwedzi inobereka zuva risati rasvika musi waJanuary 1, 1900.

Excel EOMONTH Kushanda Muenzaniso

Mumufananidzo uri pamusoro, EOMONTH inoshanda kuwedzera nekubvisa nhamba yakasiyana yemwedzi kusvika musi waJanuary 1, 2016.

Izwi iri pasi apa rinoshandisa matanho anoshandiswa kupinda mubasa muSero B3 rebasa rekushanda

Kupinda Basa reEOMONTH

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

• Kunyora basa rakakwana: = EOMONTH (A3, C2) muchikamu C3;
• Kusarudza basa uye nharo dzaro kushandisa EOMONTH basa rebhokisi dialog .

Kunyange zvazvo zvichibvira kungonyora basa rakakwana riri muruoko, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi kuti vapinde nharo dzebasa.

Matanho ari pasi apa anopinda muEOMONTH basa rinoratidzwa musero B3 mumufananidzo pamusoro pekushandisa bhokisi rebasa rebasa.

Sezvo kukosha kwekupinda kweMwedzi mhirizhonga kwakaipa (-6) zuva riri mumasero B3 richave rakapfuura kutanga kwekutanga.

EOMONTH Muenzaniso - Mwedzi Yokudzinga

1. Dzvanya pane sero B3 - kuti riite iro rinoshandiswa seki;
2. Dzvanya paMafomu tab yebhoni;
3. Dzvanya paNhasi neHungu mabasa kuti uzarure basa rinoyerera pasi;
4. Dzvanya EOMONTH muburusita kuunza bhokisi rebhokisi rebasa;
5. Dzvanya paIndaneti_date mubhokisi rebhokisi;
6. Dzvanya pane sero A3 mune pepa rekushandisa kuti uise iyo seferensi mubhokisi rebhokisi seNot_date argument;
7. Dzvanya pamwedzi Mutsara mubhokisi rebhokisi;
8. Dzvanyira pa cell B2 mune pepa rekushandisa kuti uise iyo seferensi iri mubhokisi rebhokisi seMwedzi argument;
9. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubasa rekushanda;
10. Musi we7/31/2015 (July 31, 2016) - unowanikwa muchitokisi B3 iyo izuva rokupedzisira remwedzi iyo mwedzi mitanhatu isati yatangira zuva;
11. Kana nhamba, yakadai se 42216, inowanikwa muchitokisi B3 zvinogona kuti sero rine Gwaro rinoshandiswa rinoshandiswa kwairi. Ona mirairo iri pasi apa kuti uchinje sero kuti uwedzere kufambisa;
12. Kana iwe ukatora pane cell B3 zvakakwana basa = EOMONTH (A3, C2) inowanikwa mubhairi yepamusoro pane pepa pepaji.

Kuchinja Date Date Format mu Excel

Nzira yakakurumidza uye yakajeka yekushandura musi wezuva kwemasero ane EOMONTH basa ndosarudza imwe kubva pane zvakasarudzwa pakusarudza maitiro ekufambisa muFomendi Cells dialog box.

Matanho ari pasi apa anoshandisa kambani yekutsinhaniswa kwebhokisi yeCtrl + 1 (nhamba yekutanga) kuti uzarure maCentera maBhokisi e dialog box.

Kuti uchinje kusvika pamusi wezuva:

1. Simbisai masero ari mubhuku rekushanda rine kana rine zvinyorwa;
2. Dhinda ma Ctrl + 1 makii kuti uzarure Fomu Cells dialog box;
3. Dzvanya paNhamba tab mune bhokisi rebhokisi;
4. Dzvanya paDhesi muIndaneti mawindo yewindo (kuruboshwe rwebhokisi rebhokisi);
5. MuTsika yewindo (kurudyi), chengetai pane faira yezuva;
6. Kana sarudzo dzakasarudzwa dzine deta, Sample bhokisi richaratidza kutarisa kwemaitiro akasarudzwa;
7. Dzvanya kona OK kuti uchengetedze shanduko shanduka uye yevha yebhokisi rebhokisi.

Kune avo vanosarudza kushandisa mouse panzvimbo yebhokisi, imwe nzira yekuzarura bhokisi rebhokisi nderokuti:

1. Kona zvakananga masero akasarudzwa kuti azarure mamiriro ekutenderera;
2. Sarudza Mafaira Emafaira ... kubva kumenyu kuti uzarure Fomendi Cells dialog box.

###########

Kana, mushure mokunge tashandura kune imwe yemaitiro yezuva, sero rinoratidza mutsara wematekisi ane hani, ndeyekuti sero harina kukwana zvakakwana kuti iratidze data yakarongeka. Kuwedzera sero kuchagadzirisa dambudziko racho.