Kuziva kuti inguva yakadii yapfuura pakati pemakore maviri chaiwo zviri nyore sekubvisa nhamba dzadzo, zvisinei, munzvimbo dzebasa zvinodikanwa zvinowanzonyanya kuoma. Saka, Hazvina kujairika kuzviwana iwe uchida kubvisa misi yakazara muExcel gwaro.. Chirongwa ichi ndechimwe chakanangana nekuita marudzi ese emasvomhu uye kubviswa kwemazuva maviri hakuna mutsauko. Nenzira iyoyo, tichakuratidza zvese zvaunoda kuti uzive kuti uzviite uye nekuzvishandisa mumaspredishiti ako.
Kana iwe uchida kuziva kuti mazuva mangani, mwedzi kana makore apfuura pakati pemazuva maviri, wauya kunzvimbo chaiyo nekuti isu tichakupa ruzivo rwese kuti uzviite mumasekondi mashoma..
Nzira yekubvisa sei mazuva muExcel?
Kubvisa misi ibasa iro muExcel rinopa nzira dzinoverengeka dzekuwana mhedzisiro, zvisinei, ndeipi yekutora zvinoenderana nekuti tinoda kuiratidza sei.. Nenzira iyi, chirongwa chinokwanisa kuratidza mazuva apfuura, mwedzi uye makore, kunyangwe zvakasiyana. Kana iwe uchida kuona iyo yakazara ruzivo, saka iwe uchafanirwa kutora maseru matatu kuti abudise mhedzisiro yega yega uye gare gare, tora fomula yekubatanidza tambo yemavara. Nekudaro, Excel chirongwa icho mikana yakavhurika uye kune nzira dzekugadzira mafomula anotitendera kuratidza mhedzisiro yekubvisa misi mufomati yatinoda.
Pano tichaona nzira dzakareruka uye dzinosvikika dzekuzviita.
Basic date kubvisa
Iyi ndiyo nzira iri nyore yekubvisa misi muExcel uye ingori yekubvisa, kusarudza maseru ane mazuva ari mubvunzo.. Nenzira iyi, zvese zvaunofanirwa kuita ndezvekuti:
- Tinya kaviri pasero paunoda mhedzisiro.
- Isa chiratidzo chakaenzana ( = ).
- Sarudza zuva nhamba 1.
- Inoisa minus sign (-).
- Sarudza zuva nhamba 2.
- Rova Pinda.
Izvi zvinodzosera huwandu hwemazuva apfuura pakati pemazuva ese ari maviri.. Zvinofanira kucherechedzwa kuti zuva nhamba 1 inofanira kunge iri yazvino, kuitira kuti uwane nhamba yakanaka.
Kubvisa mazuva ane DATEDIF basa
Kana uri kutsvaga basa IF DATED muExcel catalogue, haungazoiwana, zvisinei, ichiri kuwanikwa uye inoshanda. Basa rayo ndere kuratidza mutsauko pakati pemazuva maviri, paine mukana wekutsanangura kana tichida kuti zviratidzirwe mumazuva, makore kana mwedzi. Nenzira iyi, kana iwe uchida kuve neruzivo rwakakwana nezvenguva yakapfuura, zvichave zvakakwana kutora maseru matatu mumutsara, imwe chete pachiyero chenguva.
Syntax yeformula iyi ndeiyi:
=DATEDIF(Date1,Date2)
Nekudaro, kusiyana neyakapfuura kesi, mune DATEDIF basa tinoda zuva nhamba 1 kuti ive yekare. Kana tikazviita neimwe nzira, chirongwa chinokanda kukanganisa #¡NUM!
Kuita kubviswa kwemazuva uye kuti mhedzisiro inoratidzwa mumazuva, mwedzi nemakore iwe unofanirwa kuita zvinotevera:
- Tinya kaviri pasero.
- Pinda basa IF DATED uye vhura maparentheses.
- Dzvanya pane zuva nhamba 1 (yekare) uye isa comma.
- Dzvanya pane zuva nhamba 2 (yazvino kwazvo) uye isa comma.
- Pinda mumakotesheni mabhii d, y uye m anomiririra mazuva, makore nemwedzi zvakateerana.
- Vhara maparenthesis.
- Rova Pinda.
Zvinoenderana nerudzi rwetsamba yawakaisa kumagumo pakati pemakotesheni, mhedzisiro icharatidzwa mumazuva, mwedzi kana makore. Saka, iwe unogona kubvisa nyore nyore misi muExcel uye uzive huwandu hwenguva yakapfuura pakati pemapoinzi maviri chaiwo pakarenda.
Mhedziso
Kubvisa misi muExcel inzira yakakosha yekuziva kune chero munhu anoshanda nedata uye anoda kuita maverengero enguva.. Kunyangwe zvingaite sezvakaomesesa pakutanga, zviri nyore kushandisa kana wanzwisisa izvo zvekutanga. Funga kuti imwe neimwe yenzira dzatinotsanangura ine hunhu hwayo uye kuzvinzwisisa zvinoenderana nekuwana mhedzisiro chaiyo.
Zvakakosha kuyeuka kuti Excel inoshandisa Ndira 1, 1900 sezuva rayo rekutanga, saka zvakakosha kuti uchengete izvi mupfungwa paunopinda misi. Pamusoro pezvo, zvinodikanwa kuti tizive maitiro ekufomatisa maseru kuitira kuti mhedzisiro ionekwe sezvatinoda.
Sezvataona, pane nzira dzakasiyana dzekubvisa misi muExcel, kubva pakushandisa DATEDIF basa kuenda kumanyorero ekuverenga uchishandisa mafomula ari nyore. Imwe neimwe nzira ine zvayakanakira nezvayakaipira, saka zvakakosha kusarudza sarudzo inonyatsoenderana nezvido zvako. Rangarira, zvakare, kuti une mukana wekudzidzira mukati mebasa rako nemaitiro ega ega kuitira kuti uzive chero uye kuti iyi ndiyo nzira yako huru yekubvisa misi muExcel.