Pogwira ntchito ku Excel, ntchito nthawi zina imayikidwa kuti mutalowa tsiku linalake, tsiku la sabata lomwe limafanana nalo limawonetsedwa m'selo. Mwachilengedwe, kuthetsa vutoli kudzera mwa purosesa yamphamvu kwambiri ya tebulo monga Excel, mwina m'njira zingapo. Tiyeni tiwone zosankha zomwe zingagwire ntchito iyi.
Onetsani tsiku la sabata ku Excel
Pali njira zingapo zowonetsera tsiku la sabata ndi tsiku lomwe adalowa, kuchokera pakupanga maselo kupita kuntchito. Tiyeni tiwone mitundu yonse yomwe ilipo yochita opangidwayi ku Excel, kuti wogwiritsa ntchito asankhe yabwino kwambiri pazomwe zili.
Njira 1: kutsatira mawonekedwe
Choyamba, tiwone momwe kusanja maselo kumakuthandizirani kuti muwonetse tsiku la sabata pofika tsiku lomwe mwalowa. Kusankha uku kumaphatikizapo kusinthitsa tsiku kukhala lololedwa, m'malo mongosunga mawonetsedwe amitundu yonseyi patsamba.
- Lowetsani tsiku lililonse lomwe lili ndi nambala, mwezi ndi chaka, m'chipindacho patsamba.
- Timadula khungu ndi batani lam mbewa. Zosintha zamakambirano zayambitsidwa. Sankhani malo mmenemu "Mtundu wamtundu ...".
- Tsamba losintha likuyamba. Pitani ku tabu "Chiwerengero"ngati idatsegulidwa mu tabu lina. Komanso mu gawo lachitetezo "Mawerengero Amanambala" khazikitsani kusintha "Makonda onse". M'munda "Mtundu" pamanja lembani mtengo wotsatirawu:
DDDDPambuyo pake, dinani batani "Zabwino" pansi pazenera.
- Monga mukuwonera, m'malo mwa tsikulo, dzina lonse la tsiku la sabata lolingana nalo lidawonetsedwa mchipindamu. Nthawi yomweyo, mutasankha khungu ili, mu fomulo yama formula muwonabe chiwonetserocho.
M'munda "Mtundu" kukonza mawindo m'malo mwa phindu DDDD mutha kuyikanso mawu oti:
DDD
Poterepa, pepalali likuwonetsa dzina lalifupi la tsiku la sabata.
Phunziro: Momwe mungasinthire mawonekedwe amtundu mu Excel
Njira 2: gwiritsani ntchito ntchito ya TEXT
Koma njira yomwe idaperekedwa pamwambapa imaphatikizapo kusintha tsiku kukhala tsiku la sabata. Kodi pali njira yoti zonsezi ziwonetsedwe papepala? Ndiye kuti, tikalowetsa tsiku limodzi mu foni imodzi, ndiye kuti tsiku la sabata limayenera kuwonetsedwa mu linanso. Inde, chisankho chotere chilipo. Itha kuchitika pogwiritsa ntchito njira MUTU. Poterepa, mtengo womwe timafunikira udawonetsedwa mu foni yolembedwa pamawonekedwe.
- Timalemba tsikulo pachinthu chilichonse. Kenako sankhani chilichonse chopanda kanthu. Dinani pachizindikiro. "Ikani ntchito"lomwe lili pafupi ndi mzere wa fomula.
- Zenera limayamba. Ogwira Ntchito. Pitani ku gulu "Zolemba" ndipo kuchokera mndandanda wa ogwiritsira ntchito sankhani dzinalo MUTU.
- Ntchito yotsutsana ndi ntchito imatsegulidwa MUTU. Wogwiritsa ntchito adapangidwa kuti awonetse nambala yomwe idasankhidwa mumitundu yomwe idasankhidwa. Ili ndi mtundu wotsatira:
= TEXT (Mtengo; Mtundu)M'munda "Mtengo" tifunika kufotokoza adilesi ya foni yomwe ili ndi deti. Kuti muchite izi, ikani cholozera m'gawo linalake ndikudina kumanzere mufoni ino. Adilesiyo imawonetsedwa nthawi yomweyo.
M'munda "Fomu" kutengera zomwe tikufuna kukhala ndi tsiku lathunthu kapena lalifupi la sabata, timayambitsa mawuwo dddd kapena ddd opanda mawu.
Mukamalowetsa izi, dinani batani "Zabwino".
- Monga tikuwona mu khungu lomwe tidasankha kumayambiriro komwe, mawonekedwe a tsiku la sabata adawonetsedwa mumawonekedwe osankhidwa. Tsopano pa pepala lathunthu tsiku ndi tsiku la sabata zikuwonetsedwa nthawi yomweyo.
Komanso, mukasintha mtengo wapadera mu cell, tsiku la sabata limangosintha momwemo. Chifukwa chake, kusintha tsiku, mutha kudziwa kuti lidzakhala tsiku lanji sabata.
Phunziro: Excel Feature Wizard
Njira 3: gwiritsani ntchito NTCHITO
Palinso othandizira ena omwe angawonetse tsiku la sabata mpaka tsiku loperekedwa. Ichi ndi ntchito. TSIKU. Zowona, sizimawonetsa dzina la tsiku la sabata, koma kuchuluka kwake. Komanso, wogwiritsa ntchito akhoza kukhazikitsa kuyambira tsiku liti (Lamlungu kapena Lolemba) kuwerengetsa kudzawerengedwa.
- Sankhani khungu kuti muwonetse tsiku la sabata. Dinani pachizindikiro "Ikani ntchito".
- Windo limatsegulanso Ogwira Ntchito. Pano tikupita ku gulu "Tsiku ndi nthawi". Sankhani dzina TSIKU ndipo dinani batani "Zabwino".
- Ipita pazenera la woyeserera TSIKU. Ili ndi mtundu wotsatira:
= TSIKU (deti_ mu_numeric_format; [mtundu])M'munda "Tsiku la manambala" lembani tsiku kapena adilesi ya foniyo papepala lomwe mulimo.
M'munda "Mtundu" kuchuluka kwa 1 kale 3, yomwe imasankha momwe masiku a sabata adzawerengedwa. Mukamaika manambala "1" kuwerengera kudzachitika kuyambira pa Sabata, ndipo nambala ya zilembo zidzaperekedwa mpaka lero la sabata "1". Mukayika mtengo "2" manambala adzachitika kuyambira Lolemba. Tsiku la sabata lidzapatsidwa nambala yotsatana "1". Mukayika mtengo "3" kuwerengetsa kudzachitika kuyambira Lolemba, koma pankhani iyi, Lolemba adzaikidwa nambala yotsatiridwa "0".
Kukangana "Mtundu" osafunikira. Koma, mukachisiya, zimawonedwa kuti phindu la mkangano ndilofanana "1"ndiye kuti sabata imayamba Lamlungu. Izi ndizachikhalidwe kumayiko olankhula Chingerezi, koma njirayi siyigwirizana ndi ife. Chifukwa chake m'munda "Mtundu" ikani mtengo wake "2".
Pambuyo pochita izi, dinani batani "Zabwino".
- Monga mukuwonera, kuchuluka kwa tsiku la sabata lomwe likufanana ndi tsiku lomwe adalowetsedwa akuwonetsedwa mu khungu lomwe lawonetsedwa. M'malo mwathu, nambala iyi "3"choyimira sing'anga.
Monga momwe zimakhalira ndi ntchito yapita, posintha tsiku, tsiku la sabata m'selo momwe wothandizira amakhalira amadzisintha.
Phunziro: Tsiku la Excel ndi ntchito za nthawi
Monga mukuwonera, ku Excel pali njira zitatu zazikulu zoperekera tsikulo ngati tsiku la sabata. Onsewa ndi osavuta ndipo safuna kuti wogwiritsa ntchito akhale ndi maluso enaake. Chimodzi mwa izo ndi kugwiritsa ntchito mawonekedwe apadera, ndipo enanso awiri amagwiritsa ntchito zomwe adapangidwa kuti akwaniritse zolinga izi. Popeza njira ndi njira zowonetsera chidziwitso pazofotokozedwa zonse ndizosiyana kwambiri, wogwiritsa ntchito ayenera kusankha njira ziti mwanjira inayake yomwe imamukomera.
