01 ye 01
Wedzera / Kubvisa Mwedzi kusvika Mazuva
EDATE Basa Rokuita
Excel's EDATE basa rinogona kushandiswa kukurumidza kuwedzera kana kubvisa mwedzi kusvika pakuzivikanwa kwemazuva - zvakadai sekukura kana kuti mazuva ekutsvaga mari kana mazuva ekutanga kana ekupedzisira emapurojekiti.
Sezvo basa racho richiwedzera kana kuti richibvisa mwedzi yose kusvikira musi, chigumisiro chicharamba chiri pamusi iwoyo wemwedzi sezuva rokutanga.
Serial Numbers
Iyo data yakadzorerwa ne EDATE basa inhamba serial kana seri seri. Isai maitiro ekufambisa kune masero ane EDATE basa kuitira kuti aratidze mazuva akakwana mubheji remabasa - rakataurwa pasi apa.
Dhiyabhorosi yeState Function uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara we EDATE basa nderokuti:
= EDATE (Start_date, Mwedzi)
Start_date - (inoda) zuva rokutanga reprojekti kana nguva inobvunzwa
- iyi nharo inogona kunge iri zuva rakapinda mubasa kana sechitarisiko chesero kune nzvimbo yedhesi mubasa rekushanda
Mwedzi - (inotarisirwa) - nhamba yemwedzi mushure mokunge kana mushure mokutanga_date
- iyi nharo inogona kuva inokosha yakapinda mubasa kana sechitarisiko chekero kune nzvimbo yedhesi mubasa rekushanda
- maonero akanaka anopa nguva yemberi - mutsara 8 mumufananidzo wepamusoro
- Maitiro asina kunaka akapfuura mazuva - mutsara 3 mumufananidzo uri pamusoro
Kana mwedzi isati iri nhamba, inotorwa (chikamu chekudarika chakabviswa) - sezvinoratidzwa mumutsara we8 mumufananidzo pamusoro apa apo makore 12.25 akatarirwa kune integer 12
#VALUE! Error Value
Kana iyo Start_date nharo isiri zuva rakakodzera, basa rinodzorera #VALUE! kukanganisa kukosha - sezvakaratidzwa mumutsara wechina mumufananidzo wepamusoro, kubvira musi wa2/30/2016 (February 30, 2016) hazvina kukodzera
Excel's EDATE Function Example
Sezvinoratidzwa mumufananidzo uri pamusoro, muenzaniso uyu unoshandisa EDATE basa kuwedzera nekubvisa nhamba yakasiyana yemwedzi kusvika musi waJanuary 1, 2016.
Izwi iri pasi apa rinoshandisa matanho anoshandiswa kupinda mubasa mumasero B3 neC3 emushandi webasa.
Kupinda EDATE Basa
Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:
- Kunyora basa rakakwana: = EDATE ($ A $ 3, C2) muchitokisi C3;
- Kusarudza basa uye mazano aro uchishandisa EDATE basa dialog box.
Kunyange zvazvo zvichibvira kungonyora basa rakakwana riri muruoko, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi kuti vapinde nharo dzebasa.
Nhanho dziri pasi apa dzinopinda muEEDATE basa rinoratidzwa musero B3 mumufananidzo pamusoro pekushandisa bhokisi rebasa rebasa.
Sezvo hutsika dzichizopindirwa kweMwedzi nharo dzisina kunaka (-6 uye -12) mazuva ari mumasero B3 neC3 achave apfuura kupfuura zuva rokutanga.
EDATE Muenzaniso - Mwedzi Yokubvisa
- Dzvanya pane sero B3 - kuti riite iro rinoshandiswa seki;
- Dzvanya paMafomu tab yebhoni;
- Dzvanya paNhasi neHungu mabasa kuti uzarure basa rinoyerera pasi;
- Dzvanya EDATE muurongwa kuti ubudise basa rebhokisi rebhokisi;
- Dzvanya paIndaneti_date mubhokisi rebhokisi;
- Dzvanya pane sero A3 mune pepa rekushandisa kuti uise iyo seferensi mubhokisi rebhokisi seNot_date argument;
- Dhinda f4 key pa keyboard kuitira kuti A3 ive nhepfenyuro yakakwana - $ A $ 3;
- Dzvanya pamwedzi Mutsara mubhokisi rebhokisi;
- Dzvanyira pa cell B2 mune pepa rekushandisa kuti uise iyo seferensi iri mubhokisi rebhokisi seMwedzi argument;
- Dzvanya OK kuti upedze basa uye dzokera kubheji rekushanda;
- Musi we 7/1/2015 (July 1, 2015) - unowanikwa muchitokisi B3 iyo mwedzi mitanhatu isati yatangira zuva;
- Shandisa gadziriro yekuzadza kuti ukope EDATE basa kumusero C3 - musi wa2011/2015 (January 1, 2015) inofanira kuonekwa muchitokisi C3 iyo mwedzi 12 isati yatanga zuva;
- Kana iwe ukatora pane cell C3 basa rakakwana = EDATE ($ A $ 3, C2) inowanikwa mubhairi yepamusoro pane pepa pepaji;
Cherechedza : Kana nhamba, yakadai se 42186 , inowanikwa muchitokisi B3 zvinenge zvichiita kuti sero rine Gwaro rinoshandiswa rinoshandiswa kwairi. Ona mirairo iri pasi apa kuti uchinje sero kuti uwedzere kufambisa;
Kuchinja Date Date Format mu Excel
Nzira yakakurumidza uye yakajeka yekushandura mafomu ezuva remasero ane EDATE 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:
- Simbisai masero ari mubhuku rekushanda rine kana rine zvinyorwa
- Dhinda makira eCtrl + 1 kuti uzarure Fomu Cells dialog box
- Dzvanya paNhamba tab mune bhokisi rebhokisi
- Dzvanya paDhesi muIndaneti mawindo yewindo (kuruboshwe rwebhokisi rebhokisi)
- Muchiri Wemwindo (kuruboshwe rworudyi), chengetedza pane yaunoda zuva format
- Kana sarudzo dzakasarudzwa dzine deta, Sample bhokisi richaratidza kutarisa kwemaitiro akasarudzwa
- Dzvanya kona OK kuti uchengetedze shanduko shanduka uye yevha yebhokisi rebhokisi
Kune avo vanosarudza kushandisa mouse panzvimbo yebhokisi, imwe nzira yekuzarura bhokisi rebhokisi nderokuti:
- Kona zvakananga masero akasarudzwa kuti azarure mamiriro ekutenderera
- 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.