Umunsi wicyumweru kuganaho neza

Iyo ukorera muri Excel, umurimo rimwe na rimwe uzamurwa kugirango nyuma yitariki yihariye mu Kagari, umunsi wicyumweru, uhuye nacyo. Mubisanzwe, birashoboka gukemura iki gikorwa binyuze mumeza akomeye nkubuhungiro, birashoboka muburyo butandukanye. Reka turebe uburyo buhari bwo gukora iki gikorwa.

Kugaragaza umunsi wicyumweru muri Excele

Hariho inzira nyinshi zo kwerekana umunsi wicyumweru cyitariki, uhereye kumiterere ya selile hanyuma ugangirira kubikoresha imirimo. Reka turebe uburyo bwose buriho bwo gukora ibikorwa byagenwe muri Excele kugirango uyikoresha ashobore guhitamo ibyiza muribihe byihariye.

Uburyo 1: Gusaba

Mbere ya byose, reka turebe uburyo imiterere ya selile ishobora kugaragara umunsi wicyumweru cyitariki. Ihitamo risobanura itariki ihinduka ku gaciro kagenwe, kandi ntugatere kwerekana ubundi bwoko bwamakuru yombi kurupapuro.

1. Tumenyekanisha itariki iyo ari yo yose irimo amakuru kuri nimero, ukwezi numwaka, muri kasho ku rupapuro.



2. Kanda ahanditse buto yimbeba iburyo. Ibikubiyemo byatangijwe. Twahisemo muri yo umwanya "imiterere ingirabuzimafatizo ...".



3. Idirishya ryahinduwe. Kwimukira muri "umubare" niba wafunguye izindi tab. Ibikurikira, muri "Imiterere yumubare", twashyize ahagaragara kumwanya wa "format zose". Muri "ubwoko" umurima winjire agaciro kakurikira:

   Dddd

   Nyuma yibyo, kanda kuri buto "OK" hepfo yidirishya.



4. Nkuko mubibona, mukagari aho kuba itariki, izina ryuzuye ryumunsi wicyumweru rirakwiye. Mugihe kimwe, hitamo iyi selire, muri formulain umurongo uracyabona kwerekana itariki.

Mumwanya wa "Ubwoko" bwibikoresho byerekana, aho kuba agaciro ka DDMD, urashobora kandi kwinjira mu mvugo:

Ddd

Muri iki gihe, urutonde ruzerekana izina rikubiyeho umunsi wicyumweru.

Isomo: Nigute ushobora guhindura imiterere yimodoka mu buhungiro

Uburyo 2: Gukoresha inyandiko yimikorere

Ariko uburyo bwatanzwe haruguru butanga itariki yo guhindura itariki kumunsi wicyumweru. Hoba hariho amahitamo kugirango iyi ndangagaciro zombi zerekanwe kurupapuro? Nibyo, niba mu kazu kamwe twinjije itariki, noneho umunsi wicyumweru ugomba kwerekanwa. Nibyo, iyi nzira irahari. Irashobora gukorwa hakoreshejwe inyandiko. Muri iki kibazo, agaciro ukeneye kugaragara mumateka yerekanwe muburyo bwanditse.

1. Andika itariki kurupapuro urwo arirwo rwose. Noneho hitamo selile irimo ubusa. Kanda kuri "Shyiramo imikorere", iherereye hafi yumurongo wa formula.



2. Ikirangantego Wizard Idirishya ritangira kwiruka. Jya mucyiciro "Inyandiko" no kurutonde rwabakora, hitamo izina "inyandiko".



3. Idirishya ryinyandiko Idirishya rifungura. Uyu mukoresha ahamagarwa kugirango asohoke umubare wagenwe muri verisiyo yatoranijwe yimiterere yinyandiko. Ifite syntax ikurikira:

   = Inyandiko (agaciro; imiterere)

   Mu murima "agaciro", dukeneye kwerekana aderesi ya selile irimo itariki. Kugirango ukore ibi, shiraho indanga kumurima wagenwe na buto yimbeba yibumoso kanda kuri selile kurupapuro. Aderesi izahita igaragara.

   Mu murima "imiterere" ukurikije icyo dushaka kugira kubona umunsi wicyumweru cyuzuye cyangwa amagambo ahinnye, DDMD "cyangwa" DDD "nta magambo.

   Nyuma yo kwinjira muri aya makuru, kanda buto "OK".



4. Nkuko dushobora kubibona muri kasho, twahisemo mugitangira, izina ryumunsi wicyumweru ryerekanwe muburyo bwatoranijwe. Ubu dufite itariki ku rupapuro nitariki, kandi umunsi wicyumweru icyarimwe.

Byongeye kandi, niba muri kasho kugirango uhindure agaciro, hanyuma rero uhite uhindure umunsi wicyumweru. Rero, guhindura itariki ushobora kumenya kumunsi wicyumweru uzaba ugomba.

Isomo: Master of Imikorere muri Excele

Uburyo 3: Gushyira mubikorwa imikorere yumunsi

Hariho undi mukoresha ushobora kuzana umunsi wicyumweru kumunsi watanzwe. Uyu ni umurimo wumunsi. Nibyo, agaragaza izina ryumunsi wicyumweru, ariko numero ye. Muri icyo gihe, umukoresha arashobora gushyirwaho kuva kumunsi (kuva ku cyumweru cyangwa kuwa mbere) umubare uzabarirwa.

1. Turagaragaza selire kubisohoka byumunsi wicyumweru. Kanda kuri "Shyiramo imikorere".



2. Idirishya rya Wizard Wizard rifungura. Iki gihe tujya mucyiciro "itariki nigihe". Hitamo izina "uburyo" hanyuma ukande buto "OK".



3. Inzibacyuho ku mpaka zimpaka zabigenewe zirakorwa. Ifite syntax ikurikira:

   = Uburyo (itariki_imbere_imfor; [ubwoko])

   Muri "itariki muburyo bwumubare", twinjiza itariki cyangwa aderesi ya selire kurupapuro rurimo.

   Muri "ubwoko", umubare washyizweho kuva 1 kugeza 3, ugena neza uko iminsi yicyumweru izaba ibaruwe. Iyo ushizemo umubare "1", umubare uzabaho kuva ku cyumweru, kandi uyu munsi wicyumweru uzahabwa nimero ikurikira "1". Mugihe ushyiraho agaciro "2", umubare uzakorwa, guhera kuwa mbere. Uyu munsi wicyumweru uzahabwa nimero ikurikira "1". Mugihe ushyiraho agaciro "3", umubare nazo bizaba ku wa mbere, ariko muriki gihe Ku wa mbere uzahabwa nimero ikurikira "0".

   Impaka "Ubwoko" ntabwo ari itegeko. Ariko, niba yarasibwe, bizera ko agaciro k'impaka ari "1", ni ukuvuga ko icyumweru gitangira ku cyumweru. Yemerwa rero mubihugu bivuga icyongereza, ariko ubu buryo ntabwo bukwiye kuri twe. Kubwibyo, muburyo bwa "bwoko", twashyizeho agaciro "2".

   Nyuma yo kurangiza ibyo bikorwa, kanda kuri buto "OK".



4. Nkuko tubibona, umubare wicyumweru cyicyumweru cyerekanwe mumateka yagenwe, bihuye nitariki yinjiye. Ku bitureba, iyi niyo nimero "3", bivuze kuwa gatatu.

Nkibi hamwe nimikorere yabanjirije iyi, itariki yumunsi wicyumweru yahise ihinduka mugihe itariki yahinduwe mukagari umukoresha yashizwemo.

Isomo: Itariki nigihe cyimikorere muri Excele

Nkuko mubibona, hariho uburyo butatu bwingenzi bwitariki yicyumweru. Bose barimo byoroshye kandi ntibisaba ubuhanga bwihariye kubakoresha. Imwe murimwe nugukoresha imiterere idasanzwe, kandi abandi babiri bakoresha imirimo yashyizwe kugirango bagere kuri izo ntego. Urebye ko uburyo nuburyo bwo kwerekana amakuru muri buri rubanza rwasobanuwe butandukanye cyane, umukoresha agomba guhitamo uburyo bwerekanwe mubihe runaka bikwiranye na byose.