Itariki nigihe cyimikorere muri Excel

Imwe mu matsinda ashakishwa cyane-nyuma yabakoresha mugihe bakorana na excel ameza ni amatariki nigihe cyigihe. Nubufasha bwabo ushobora gukora manipuline zitandukanye namakuru yigihe gito. Itariki nigihe bikunze gushyirwaho mugihe utanga ibiti bitandukanye muri Excel. Gutunganya amakuru nkaya niyo mirimo nyamukuru yabakora haruguru. Reka tumenye aho ushobora gusanga iri tsinda ryimikorere muri progaramu ya porogaramu, nuburyo bwo gukora hamwe nibitekerezo byateganijwe cyane.

Gukorana namatariki nigihe ntarengwa

Itsinda ryamatariki nigihe cyimikorere ashinzwe gutunganya amakuru yatanzwe kumunsi cyangwa igihe. Kugeza ubu, Excel ifite abakoresha barenga 20, bakubiye muri iyi formula. Hamwe no kurekura verisiyo nshya ya Excel, umubare wabo uhora wiyongera.

Imikorere iyo ari yo yose irashobora kwinjizwa mu ntoki, niba uzi syntax yayo, ariko kubakoresha benshi, cyane cyane badafite uburambe cyangwa urwego rwubumenyi rutari hejuru yimiterere, biba byoroshye cyane kubishushanyo mbonera, bigereranywa numurimo wizard, gukurikiranwa no kwimukira mu idirishya ryimpaka.

Kumenyekanisha formulaire binyuze mumikorere wizard, hitamo selile aho ibisubizo bizerekanwa, hanyuma ukande buto "Shyiramo. Iherereye ibumoso bwumugozi wa formula.

Himura kuri Master of Master in Microsoft Excel

Nyuma yibyo, Gukora Wizard yimikorere birakora. Dutanga gukanda kumurima "icyiciro".

Master of Imikorere muri Microsoft Excel

Kuva kurutonde rwo gufungura, hitamo "itariki nigihe".

Hitamo Imikorere Ibyiciro muri Microsoft Excel

Nyuma yibyo, urutonde rwabakora iri tsinda rufungura. Kujya kumurongo runaka, hitamo imikorere yifuzwa murutonde hanyuma ukande buto "OK". Nyuma yo gukora ibikorwa byashyizwe ku rutonde, idirishya rizatangizwa.

Inzibacyuho Kubikorwa Impaka muri Microsoft Excel

Mubyongeyeho, ibinyago bikora birashobora gukoreshwa mu kwerekana selile kurupapuro hanyuma ukande guhinduranya + F3 urufunguzo. Haracyariho amahirwe yo kwimura kuri "formula", aho kuri kaseti mumatsinda yisomero ryimikorere, kanda ahanditse "Shyiramo imikorere".

Jya kugirango ushiremo imikorere muri Microsoft Excel

Birashoboka kwimukira mu idirishya ryibintu bya formulaire yihariye kuva nitsinda ridakora idirishya nyamukuru rya shebuja wibikorwa. Gukora ibi, twimukira muri tab "formula". Kanda kuri buto "itariki". Iherereye kuri kaseti mugikoresho "cyimikorere". Urutonde rwabacuruzi bahari muriki cyiciro barakora. Hitamo imwe ikenewe kugirango ukore umurimo. Nyuma yibyo, yimukira mu idirishya ryimpaka.

Inzibacyuho Kuri formulaire muri Microsoft Excel

Isomo: Umukozi wa Wizard muri Excel

Itariki

Kimwe muri ibyoroshye, ariko ariko, imikorere ijyanye niri tsinda niyo itariki yo gufata. Yerekana itariki yatanzwe muburyo bwumubare mu Kagari, aho formula ubwayo iherereye.

Ibitekerezo byayo ni "umwaka", "ukwezi" na "umunsi". Ikintu cyo gutunganya amakuru nuko imikorere ikorana nigice cyigihe gito bitarenze 1900. Kubwibyo, niba ari impaka ", kurugero, 1898, umukoresha azerekana ibisobanuro bitari byo. Mubisanzwe, umubare nkimpaka "n '" umunsi "ni imibare, ukurikirana, kuva 1 kugeza ku ya 12 kugeza 31. Reba selile irashobora kuba impaka amakuru ahuye.

Kuburyo bw'intoki yinjira, syntax ikurikira ikoreshwa:

= Itariki (umwaka; ukwezi; umunsi)

Hafi yiki gikorwa ku gaciro k'abakora mu mwaka, ukwezi n'umunsi. Zigaragara mu Kagari Agaciro gahuye n'izina ryabo kandi ufite impaka zonyine.

Itegeko

Ubwoko bwimikorere idasanzwe ni uyikoresha wenyine. Ibara itandukaniro hagati yamatariki abiri. Ibiranga ni uko uyu mukoresha atari kurutonde rwa formulaire ya shebuja ibikorwa, bivuze ko indangagaciro zayo zihora zinjira muburyo bubi, ahubwo ni intoki, gukurikiza syntax ikurikira:

= Imizingo (nach_data; Kon_dat; Igice)

Duhereye ku bivugwamo, biragaragara ko "itariki ya mbere" na "itariki ya nyuma" ni amatariki, itandukaniro riri rigomba kubarwa. Ariko nkimpaka "igice" nigice cyihariye cyo gupima iri tandukaniro:

Umwaka (y);
Ukwezi (m);
Umunsi (d);
Itandukaniro mu mezi (YM);
Itandukaniro muminsi itazihije imyaka (yd);
Itandukaniro muminsi rirambuye amezi nimyaka (MD).

Imikorere yabaturage muri Microsoft Excel

Isomo: Umubare wiminsi hagati yamatariki muri Excel

Chistrabni

Bitandukanye numukoresha wabanjirije, formula ya chistorbDni itangwa kurutonde rwimikorere wizard. Igikorwa cyacyo ni ukubara umubare wiminsi yakazi hagati yamatariki abiri, yatanzwe nkimpaka. Byongeye kandi, hariho indi mpaka - "iminsi mikuru". Iyi mpaka irahinduka. Irerekana umubare wibiruhuko mugihe ubyiga. Iyi minsi nayo ikurwa kurubuga rusange. Forteula ibara iminsi yose hagati yamatariki abiri, usibye kuwa gatandatu, ku cyumweru, iyo minsi igaragazwa numukoresha nkikirori. Nkimpaka bashobora gukora nkuburyo butaziguye amatariki kandi ahuza selile zirimo.

Syntax isa na:

= Chistrabni (nach_data; Kon_data; [ibiruhuko])

Impaka zimikorere ya SolonBom muri Microsoft Excel

TDATA

Umukoresha wa TDAT arashimishije kuko adafite impaka. Yerekana itariki nigihe cyashizwe kuri mudasobwa. Twabibutsa ko iyi agaciro itavugururwa mu buryo bwikora. Bizakomeza gukosorwa mugihe cyo gukora umurimo kugeza kwisubiraho. Kugirango ukureho, birahagije guhitamo selile ikubiyemo imikorere, shyira indanga mumirongo ya formula hanyuma ukande kuri buto yinjira kuri clavier. Byongeye kandi, hasubirwamo buri gihe inyandiko irashobora gushyirwa mumiterere yayo. Tdat Syntax nkiyi:

= Tdata ()

Uyu munsi

Birasa cyane nibiranga ibibanjirije ukurikije ubushobozi bwayo muri iki gihe. Ntabwo ifite impaka. Ariko yerekana itariki nigihe kijya mu kagari, ariko rimwe na rimwe gusa. Syntax nayo yoroshye cyane:

= Uyu munsi ()

Iyi mikorere, kimwe niyambere, bisaba kwisubiraho kubimenya. Kwisubiraho bikorwa muburyo bumwe.

Igihe

Igikorwa nyamukuru cyigihe cyigihe nikiruhuko ku kagari kagenwe kerekanwe nimpaka zigihe. Impaka ziyi mikorere ni amasaha, iminota namasegonda. Birashobora kugaragazwa nko muburyo bwagaciro kandi nkuko byerekana ibijyanye na selile zibitswe. Iyi mikorere irasa cyane numukoresha itariki, gusa bitandukanye nigaragaza ibimenyetso byagenwe. Ubunini bwa "Isaha" birashobora gushyirwaho kuva kuri 0 kugeza 23, impaka z'umunota n'amasegonda - kuva 0 kugeza 59. Syntax ni:

= Igihe (amasaha; iminota; amasegonda)

Byongeye kandi, hafi yuwaguriza arashobora kwitwa gukora amasaha, iminota namasegonda. Barerekanwa kuri ecran agaciro k'izina ryerekana igihe cyagenwe, bugaragara nizina ryonyine ryimpaka.

Datakoma

Umunsi runaka. Ntabwo yagenewe abantu, ariko kuri gahunda. Igikorwa cyacyo ni uguhindura amatariki muburyo busanzwe kumurongo umwe uboneka kubibare muri excel. Impaka gusa yiyi mikorere ni itariki nkinyandiko. Byongeye kandi, nkuko bimeze mu mpaka, itariki yatunganijwe neza indangagaciro nyuma ya 1900. Syntax ifite ubwoko bwubu:

= Datax (itariki_Kak_tector)

Ibikoresho bya Data bikora muri Microsoft Excel

Kabiri

Umukozi ushinzwe kwerekana - erekana agaciro k'icyumweru kumatariki yagenwe kuri selile. Ariko formula yerekana izina ryumunsi, ariko nimero ikurikira. Byongeye kandi, ingingo yerekana umunsi wambere wicyumweru yashyizwe mumwanya wa "ubwoko". Noneho, niba washyizeho agaciro ka "1" muriki gice, noneho umunsi wambere wicyumweru bizafatwa ku cyumweru, niba "2" - nibindi. Ariko iyi ntabwo ari impaka ziteganijwe, mugihe umurima utuzuye, bizera ko kubara biva ku cyumweru. Impaka ya kabiri ni itariki nyayo muburyo bwumubare, umubare wurutonde rwumunsi ugomba gushyirwaho. Syntax isa nkiyi:

= Uburyo (itariki_imbere_imfor; [ubwoko])

Gusobanura imikorere muri Microsoft Excel

Norndeli

Intego yumukoresha wa Nomndeli ni ikimenyetso mumubare wa selile wize cyicyumweru kumatariki yatangiriye. Impaka mubyukuri ni itariki nubwoko bwo gusubiza agaciro. Niba ibintu byose bisobanutse hamwe nimpaka zambere, iyakabiri irasaba ibisobanuro byinyongera. Ikigaragara ni uko mu bihugu byinshi by'Uburayi ukurikije ISO mu mwaka wa ISO 8601 by'icyumweru cya mbere cyumwaka, icyumweru gifatwa nkicya kane cya mbere. Niba ushaka gukoresha iyi sisitemu yerekana, hanyuma muburyo bwo kwandika ukeneye gushyira umubare "2". Niba ushobora cyane kuri sisitemu imenyerewe, aho icyumweru cya mbere cyumwaka nicyo gigwa ku ya 1 Mutarama, noneho ugomba gushyiramo umubare "1" cyangwa uve mu murima ubusa. Syntax yimikorere ni:

= Nomedheli (itariki; [ubwoko])

Impamyabumenyi

Umukoresha wa Proled atanga urugero rushinzwe kubara igice cyumwaka cyasojwe hagati yamatariki yombi ukwezi kwumwaka. Impaka ziyi mikorere ni aya matariki yombi ari imbibi yigihe. Byongeye kandi, iyi mikorere ifite impano zidahwitse ". Irerekana uburyo bwo kubara umunsi. Mburabuzi, niba nta gaciro byasobanuwe, uburyo bwo kubara bwafashwe. Mubihe byinshi, birakwiriye gusa, akenshi iyi ngingo ntibikeneye kuzuza na gato. Syntax ifata ubwoko bwubu:

= Burden (nach_data; Kon_data; [ishingiro])

Imikorere yimikorere muri Microsoft Excel

Twanyuze gusa kubikoresha byingenzi bigize itsinda ryimikorere "itariki" muri Excel. Byongeye kandi, hari n'abandi bakoraga icumi bo mu itsinda rimwe. Nkuko mubibona, niyo imirimo yasobanuwe natwe irashobora koroshya cyane abakoresha gukorana indangagaciro zimiterere nkitariki nigihe. Ibi bintu bikwemerera kwinjiza imibare. Kurugero, mugutangiza itariki cyangwa umwanya kuri selile. Utarinze gucunga imicungire yibi bintu, ntibishoboka kuvuga kubyerekeye ubumenyi bwiza bwa gahunda ya Excel.