Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel
  • DAY ntchito
  • Ntchito CLEAR
  • TSIKU LA NTCHITO ntchito

Mu phunziro ili, muphunzira momwe mungapezere tsiku la sabata kuchokera pa deti la Excel komanso momwe mungawerengere kuchuluka kwa masiku apakati pa sabata / masiku ogwira ntchito pakati pa masiku awiri.

DAY ntchito

  1. ntchito TSIKU (WEEKDAY) mu Excel amabweretsa nambala pakati pa 1 (Lamlungu) ndi 7 (Loweruka) kuimira chiwerengero cha tsiku la sabata. Zikuwoneka kuti Disembala 16, 2013 munjira yomwe ili pansipa ikugwera Lolemba.

    =WEEKDAY(A1)

    =ДЕНЬНЕД(A1)

  2. Mukhozanso kugwiritsa ntchito ntchitoyi kuti muwonetse tsiku la sabata TEXT (TEKS).

    =TEXT(A1,"dddd")

    =ТЕКСТ(A1;"дддд")

    Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel

  3. Pangani makonda a deti (dddd) kuti muwonetse dzina la tsiku la sabata.

    Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel

Ntchito CLEAR

  1. ntchito NTCHITO WOYERA (NETWORKDAYS) imabweretsanso chiwerengero cha masiku apakati pa sabata (kupatula Loweruka ndi Lamlungu) pakati pa masiku awiri.

    =NETWORKDAYS(A1,B1)

    =ЧИСТРАБДНИ(A1;B1)

    Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel

  2. Ngati inu mwachindunji mndandanda wa maholide, ndiye ntchito NTCHITO WOYERA (NETWORKDAYS) adzabwezera chiwerengero cha masiku ogwira ntchito (kupatula Loweruka ndi Lamlungu ndi tchuthi) pakati pa masiku awiri.

    =NETWORKDAYS(A1,B1,E1:E2)

    =ЧИСТРАБДНИ(A1;B1;E1:E2)

    Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel

    Kalendala ili pansipa ikuthandizani kumvetsetsa bwino ntchitoyo NTCHITO WOYERA (MASIKU A NETWORKS).

    Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel

  3. Excel imasunga madeti ngati manambala ndipo imawerengera masiku kuyambira pa Januwale 0, 1900. M'malo mosintha ma cell angapo m'malo mwake, m'malo mwa manambala okhazikika omwe amayimira madetiwo. Kuti muchite izi, sankhani E1:E2 mu chilinganizo pansipa ndipo dinani F9.

    =NETWORKDAYS(A1,B1,{41633;41634})

    =ЧИСТРАБДНИ(A1;B1;{41633;41634})

    Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel

TSIKU LA NTCHITO ntchito

  1. ntchito TSIKU LA NTCHITO (TSIKU LA NTCHITO) pafupifupi ntchito zosiyana NTCHITO WOYERA (MASIKU A NETWORKS). Imabwezeranso tsiku lisanakwane kapena pambuyo pa kuchuluka kwa masiku apakati apakati (kumapeto kwa sabata sikuphatikizidwa).

    =WORKDAY(A1,B1)

    =РАБДЕНЬ(A1;B1)

    Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel

Zindikirani: ntchito TSIKU LA NTCHITO (TSIKU LA NTCHITO) ibweza nambala ya sirio ya tsikulo. Ikani mtundu wa deti ku selo kuti muwonetse.

Kalendala ili pansipa ikuthandizani kumvetsetsa bwino ntchitoyo TSIKU LA NTCHITO (TSIKU LA NTCHITO).

Kuwerengera masiku a sabata ndi masiku ogwira ntchito mu Excel

Kachiwiri, ngati inu m'malo mndandanda wa maholide, ntchito TSIKU LA NTCHITO (TSIKU LA NTCHITO) idzabweza tsiku lisanafike kapena pambuyo pa chiwerengero cha masiku ogwirira ntchito (kupatula Loweruka ndi Lamlungu ndi tchuthi).

Siyani Mumakonda