Kuti muchite ntchito zina mu Excel, muyenera kudziwa masiku angapo apita pakati pa masiku ena. Mwamwayi, pulogalamuyi ili ndi zida zomwe zingathetse vutoli. Tiyeni tione momwe mungathe kuwerengera kusiyana kwa tsiku mu Excel.
Kuwerengera chiwerengero cha masiku
Musanayambe kugwira ntchito ndi masiku, muyenera kupanga ma selo a mtundu uwu. Nthaŵi zambiri, pamene malemba ofanana ndi tsiku alowa, selo lokha limasinthidwa. Koma ndi bwino kuti muzichita izi kuti mutsimikizidwe kuti muthane ndi zodabwitsa.
- Sankhani danga la pepala limene mukufuna kukonzekera. Dinani botani lamanja la mouse pamasankhidwe. Menyu ya nkhaniyi yatsegulidwa. M'menemo, sankhani chinthucho "Maselo ...". Mwinanso, mungathe kulembetsa njira yachinsinsi Ctrl + 1.
- Zowonetsera zojambula zimatsegula. Ngati kutsegula sikuli mu tab "Nambala"ndiye pitani mmenemo. Muzitsulo zamkati "Maofomu Owerengeka" ikani kasinthasintha kuti muyime "Tsiku". Gawo lomanja lawindo, sankhani mtundu wa deta yomwe mungagwire nawo ntchito. Pambuyo pake, kukonza kusintha, dinani pa batani. "Chabwino".
Tsopano deta zonse zomwe zidzakhala mu maselo osankhidwa, pulogalamuyo idzazindikira ngati tsiku.
Njira 1: Kuwerengetsa Kwapafupi
Njira yosavuta yowerengera kusiyana pakati pa masiku pakati pa masiku ndi ndondomeko yosavuta.
- Timalemba m'ndandanda wamtundu wosiyana wa selo, kusiyana pakati pa zomwe mukufuna kuwerenga.
- Sankhani selo limene zotsatira zake zidzawonetsedwa. Iyenera kukhala yofanana. Chimaliziro ndi chofunika kwambiri, chifukwa ngati pali fomu yamakono mu selo ili, ndiye zotsatira zake zidzakhala "dd.mm.yy" kapena china, chogwirizana ndi mtundu uwu, chomwe ndi zotsatira zosalondola za kuwerengera. Mtundu wamakono wa selo kapena mtundu ungathe kuwonedwa powasankha pa tabu "Kunyumba". M'kati mwa zipangizo "Nambala" ndi munda umene chizindikirochi chikuwonetsedwa.
Ngati ili ndi phindu lina osati "General"ndiye pakadali pano, monga kale, pogwiritsira ntchito mndandanda wazomwe timayambitsa zowonjezera zenera. Mmenemo mu tab "Nambala" ikani mawonekedwe a mawonekedwe "General". Timakanikiza batani "Chabwino".
- Mu selo losinthidwa pansi pa mawonekedwe omwe timayika "=". Dinani mu selo kumene nthawi yotsatira ya masiku awiri ilipo (chomaliza). Kenaka, dinani chizindikiro cha kambokosi "-". Pambuyo pake, sankhani selo liri ndi tsiku loyambirira (poyamba).
- Kuti muwone nthawi yodutsa pakati pa masiku amenewa, dinani pa batani. Lowani. Zotsatira zimasonyezedwa mu selo yomwe imapangidwira monga mtundu wamba.
Njira 2: ntchito RAZHDAT
Kuti muone kusiyana kwa masiku, mutha kugwiritsa ntchito ntchito yapadera. RAZNAT. Vuto ndiloti palibe ntchito mu mndandanda wa masters ntchito, kotero muyenera kulowa ndondomeko pamanja. Mawu ake omasulira ndi awa:
= RAZNAT (kuyamba_date; kutha_date; imodzi)
"Chigawo" - iyi ndi maonekedwe omwe zotsatira zidzawonetsedwa mu selo losankhidwa. Zimatengera kuti ndi chikhalidwe chiti chomwe chidzalowe m'malo mwa parameter iyi, momwe zigawo zomwe zotsatira zibwezeretsedwa:
- "y" - zaka zonse;
- "M" - miyezi yonse;
- "d" - masiku;
- "YM" ndi kusiyana pakati pa miyezi;
- "MD" - kusiyana pakati pa masiku (miyezi ndi zaka sizinawerengedwe);
- "YD" ndi kusiyana kwa masiku (zaka sizinawerengedwe).
Popeza tikuyenera kuwerengera kusiyana kwa chiwerengero cha masiku pakati pa masiku, njira yabwino kwambiri ndiyo kugwiritsa ntchito njira yotsiriza.
Muyeneranso kuzindikira kuti, mosiyana ndi njirayo pogwiritsira ntchito ndondomeko yosavuta yomwe yafotokozedwa pamwambapa, pamene ntchitoyi iyenera kukhala yoyamba, ndipo yomaliza - yachiwiri. Apo ayi, ziwerengero sizidzakhala zolakwika.
- Lembani ndondomekoyi mu selo losankhidwa, malinga ndi mawu ake ofotokozera, omwe tawatchula pamwambapa, ndi deta yoyamba ngati mawonekedwe oyambira ndi kutha.
- Kuti muwerenge, dinani batani Lowani. Pambuyo pake, zotsatira, mwa mawonekedwe a nambala yomwe ikuwonetsera chiwerengero cha masiku pakati pa masiku, idzawonetsedwa mu selo yeniyeni.
Njira 3: Terengani nambala ya masiku ogwira ntchito
Mu Excel, ndi kotheka kuwerengera masiku ogwira ntchito pakati pa masiku awiri, ndiko kuti, kupatula kumapeto kwa sabata ndi maholide. Kuti muchite izi, gwiritsani ntchito ntchitoyi OLEMBEDWA. Mosiyana ndi woyendetsa wapitala, amapezeka mndandanda wa masters ntchito. Chidule cha ntchitoyi ndi ichi:
= OTHANDIZA (kuyamba_date; kutha_date; [maholide])
Mu ntchitoyi, zifukwa zazikulu ndi zofanana ndi woyendetsa RAZNAT - tsiku loyamba ndi kutha. Kuphatikizanso apo, pali ndondomeko yodzifunira "Maholide".
Mmalo mwake, nthawi ya maholide a anthu onse, ngati alipo, pa nthawi yomwe yophimbidwa iyenera kukhala m'malo mwawo. Ntchitoyi ikuwerengera masiku onse a mtengo wotchulidwa, kupatulapo Loweruka, Lamlungu, komanso masiku omwe anagwiritsidwa ntchito ndi otsutsa "Maholide".
- Sankhani selo yomwe idzakhala ndi zotsatira za mawerengedwe. Dinani pa batani "Ikani ntchito".
- Ntchito wiziti imatsegulidwa. M'gululi "Mndandanda wathunthu wa alfabeti" kapena "Tsiku ndi Nthawi" ndikuyang'ana chinthu "CHISTRABDNY". Sankhani ndipo dinani pa batani. "Chabwino".
- Ntchito yotsutsana yenera ikutsegula. Lowani m'madera oyenera tsiku loyambira ndi kutha kwa nthawi, komanso masiku a maholide, ngati zilipo. Timakanikiza batani "Chabwino".
Pambuyo pazigawo zomwe tafotokozazi, chiwerengero cha masiku ogwira ntchito pa nthawiyi chidzawonetsedwa mu selo losankhidwa kale.
Phunziro: Wowonjezera Wogwira Ntchito
Monga momwe mukuonera, Excel imapatsa wogwiritsa ntchitoyo chida chothandizira powerengera chiwerengero cha masiku pakati pa masiku awiri. Pankhaniyi, ngati mutangofunika kuwerengera kusiyana kwa masiku, ndiye kuti njira yowonjezereka ingakhale yogwiritsira ntchito ndondomeko yochotsa yosavuta, osati kugwiritsa ntchito ntchitoyo RAZNAT. Koma ngati mukufuna, mwachitsanzo, kuti muwerenge chiwerengero cha masiku ogwira ntchito, ndiye kuti ntchitoyo idzapulumutsidwa OLEMBEDWA. Izi zikutanthauza kuti, monga nthawi zonse, wogwiritsa ntchito ayenera kusankha chogwiritsira ntchito pomaliza ntchito yake.
