Kuwerengera Kusiyanitsa kwa Microsoft mu Microsoft Excel

Kuti mugwire ntchito zina ku Excel, muyenera kudziwa kuti papita masiku angati masiku angapo. Mwamwayi, pulogalamuyi ili ndi zida zomwe zitha kuthetsa nkhaniyi. Tiyeni tiwone momwe mungawerengere kusiyana kwa tsiku la Excel.

Kuwerengetsa masiku

Musanayambe kugwira ntchito ndi madeti, muyenera kupanga maselo amtunduwu. Nthawi zambiri, mukalowetsa chinthu chomwe chimafanana ndi deti, khungu limasinthanso. Koma ndibwino kuzichita pamanja kuti mudziteteze ku zodabwitsa.

1. Sankhani malo omwe mungakonde kuwerengera. Dinani kumanja posankha. Zosankha zamakina adatha. Mmenemo, sankhani chinthucho "Mtundu wamtundu ...". Kapenanso, mutha kulemba njira yachidule pa kiyibodi Ctrl + 1.



2. Tsamba losintha likutsegulidwa. Ngati kutsegulako sikunachitike tabu "Chiwerengero"ndiye muyenera kulowamo. Pakadutsa magawo "Mawerengero Amanambala" ikani kusintha Tsiku. Mu gawo loyenera la zenera, sankhani mtundu wa data yomwe tidzagwire nawo. Pambuyo pake, kukonza zosintha, dinani batani "Zabwino".

Tsopano deta yonse yomwe idzakhale muma cell osankhidwa, pulogalamuyo idzazindikira ngati tsiku.

Njira 1: kuwerengera kosavuta

Njira yosavuta ndiyo kuwerengera kusiyana kwa masiku pakati pa masiku pogwiritsa ntchito njira yofananira.

1. Timalemba m'magulu osiyanasiyana a masanjidwewo, kusiyana komwe kumayenera kuwerengedwa.



2. Sankhani khungu lomwe zotsatira zikuwonetsedwa. Iyenera kukhazikitsidwa ngati mtundu wamba. Mkhalidwe womaliza ndi wofunikira kwambiri, chifukwa ngati mawonekedwe ake ali mu foni iyi, ndiye kuti zotsatirazi zikuwoneka "dd.mm.yy" kapena wina, wolingana ndi mawonekedwe awa, omwe ndi cholakwika pakuwerengera. Mitundu yamakono ya khungu kapena mtundu ungawonedwe ndikuwonetsa pa tabu "Pofikira". Mu bokosi la zida "Chiwerengero" pali gawo lomwe chizindikiro ichi chikuwonetsedwa.

   

   Ngati ili ndi phindu lina kuposa "General", ndiye pankhani iyi, monga nthawi yapita, tikugwiritsa ntchito menyu wazomwe timayambitsa zenera. M'mawuwo "Chiwerengero" khazikitsani mtundu "General". Dinani batani "Zabwino".



3. Mu khungu lomwe limapangidwira mtundu wonsewo, ikani chikwangwani "=". Dinani pa cell pomwe nthawi yamapeto awiriwo (kumapeto) ili. Kenako, dinani chikwangwani "-". Pambuyo pake, sankhani khungu lomwe lili ndi tsiku loyambirira (kuyamba).



4. Kuti muwone kuti padutsa nthawi yayitali bwanji pakati pa madeti awa, dinani batani Lowani. Zotsatira zake ziwonetsedwa mu khungu lomwe limapangidwira mtundu wamba.

Njira 2: RANDATE ntchito

Mutha kugwiritsa ntchito ntchito yapadera kuwerengera kusiyana kwa masiku. HAND. Vutoli ndikuti mulibe mndandanda wa Ma Wizadi Ogwira Ntchito, ndiye kuti muyenera kulemba mwanjira. Matchulidwe ake ndi awa:

= DATE (kuyamba_dikidwani; kumapeto_dongosolo; gawo)

"Gulu" Ndiwu mtundu womwe zotsatira zake zikuwonetsedwa mu foni yosankhidwa. Khalidwe lomwe magawo omwe zotsatira zake zidzabwezeretsedwera zimatengera mtundu omwe adzaikidwe mzerewu:

• "y" - zaka zathunthu;
• "m" - miyezi yathunthu;
• "d" - masiku;
• "YM" - kusiyana m'miyezi;
• "MD" - kusiyana m'masiku (miyezi ndi zaka sikumakumbukiridwa);
• "YD" - kusiyana m'masiku (zaka sizikumbukiridwa).

Popeza tikuyenera kuwerengera kuchuluka kwa masiku pakati pa masiku, yankho labwino kwambiri lingakhale kugwiritsa ntchito njira yotsatirayi.

Muyeneranso kuganizira kuti, mosiyana ndi njira yogwiritsira ntchito njira yosavuta yomwe tafotokozera, mukamagwiritsa ntchito ntchitoyi, tsiku loyambira liyenera kukhala pamalo oyamba, ndipo tsiku lomaliza likhale lachiwiri. Kupanda kutero, kuwerengetsa sikungakhale kolondola.

1. Tikulemba chilinganizo mu selo yosankhidwa, malinga ndi momwe zidafotokozedwera pamwambapa, ndi data yoyamba momwe imayambira ndi tsiku lomaliza.



2. Kuti muwerenge, dinani batani Lowani. Pambuyo pake, zotsatira zake, mawonekedwe a nambala yakuwonetsa kuchuluka kwa masiku pakati pa madeti, adzawonetsedwa mufoni yokhazikika.

Njira 3: kuwerengera Masiku Ogwira Ntchito

Ku Excel, ndizothekanso kuwerengetsa masiku ogwira ntchito pakati pa masiku awiri, ndiye kuti, kupatula sabata ndi tchuthi. Kuti muchite izi, gwiritsani ntchito ntchito ZOLAKWIRA. Mosiyana ndi mawu am'mbuyomu, ilipo m'ndandanda wa Ogwira Ntchito. Syntax yantchitoyi ndi motere:

= NET (kuyamba_dikidwani; kumapeto_ kumapeto; [maholide])

Mu ntchitoyi, mfundo zazikulu ndizofanana ndi wothandizira HAND - kuyamba ndi tsiku lomaliza. Kuphatikiza apo, pali mkangano wosankha. "Tchuthi".

M'malo mwake, muyenera kulowetsa masiku a tchuthi chapagulu, ngati alipo, kwa nthawi yoyambitsidwa. Ntchitoyi imawerengera masiku onse a mndandanda wotchulidwa, kupatula Loweruka, Lamlungu, komanso masiku omwe amawonjezeredwa ndi ogwiritsa ntchito pamkangano "Tchuthi".

1. Sankhani khungu lomwe mawerengero azikhala. Dinani batani "Ikani ntchito".



2. Wizard wa Ntchito akutsegulidwa. Gulu "Mndandanda wathunthu wa zilembo" kapena "Tsiku ndi nthawi" kufunafuna chinthu "CHISTRABDNI". Sankhani ndikudina batani. "Zabwino".



3. Ntchito yotsutsana ndi ntchito imatsegulidwa. Lowetsani tsiku loyambira ndi kutha kwa nthawi, komanso masiku a tchuthi, ngati alipo, m'magawo oyenera. Dinani batani "Zabwino".

Pambuyo pamanambala obwezedwa pamwambapa, kuchuluka kwa masiku ogwirira ntchito panthawiyi adzawonetsedwa mu foni yosankhidwa kale.

Phunziro: Ntchito Wizard ku Excel

Monga mukuwonera, Excel imapatsa wogwiritsa ntchito chida chosavuta chowerengera masiku pakati pa masiku awiri. Komanso, ngati mukungofunika kuwerengera kusiyana kwa masiku, ndiye kuti njira yabwino kwambiri ndi kugwiritsa ntchito njira yosavuta yotulutsira, m'malo mongogwiritsa ntchito HAND. Koma ngati mukufuna, mwachitsanzo, kuti muwerenge kuchuluka kwa masiku ogwira ntchito, ntchitoyo idzakuthandizani NETWORKS. Ndiye kuti, monga nthawi zonse, wosuta ayenera kusankha pazomwe angapangire zida zake atayika kale.