Ungalunquma kanjani usuku lwesonto kusuka osukwini ku-Excel

Ngokuvamile, abasebenzisi bespredishithi se-Excel badinga ukwenza isenzo esinjengokubonisa igama losuku lweviki elihambisana neseli ethile. I-Excel inohlu olubanzi lwemisebenzi ekuvumela ukuthi usebenzise le nqubo. Esihlokweni, sizocubungula ngokuningiliziwe izindlela ezimbalwa zendlela yokubonisa kahle usuku lwesonto ngosuku.

Ukubonisa usuku lweviki kusetshenziswa ifomethi yeseli

Impahla eyinhloko yale ndlela yukuthi ngesikhathi sokukhohlisa kuphela umphumela wokugcina uzoboniswa okubonisa usuku lwesonto. Usuku ngokwalo angeke luvezwe, ngamanye amazwi, usuku osenkundleni luzothatha usuku olufiselekayo lwesonto. Idethi izovela emugqeni wefomula emisiwe lapho kukhethwa iseli. Ukuhamba:

1. Isibonelo, sineseli yethebhulethi ekhombisa idethi ethile.

2. Chofoza kwesokudla kuleli seli. Imenyu yokuqukethwe encane iboniswe esikrinini. Sithola into ebizwa ngokuthi “Fometha Amaseli …” bese uchofoza kuyo ngenkinobho yegundane engakwesokunxele.

3. Sagcina sisefasiteleni elibizwa ngokuthi “Format Cells”. Sithuthela esigabeni "Inombolo". Ohlwini oluncane "Amafomethi ezinombolo" khetha into "(wonke amafomethi)". Sibheka umbhalo othi "Uhlobo:". Chofoza inkinobho yegundane kwesokunxele endaweni yokokufaka etholakala ngezansi kwalo mbhalo. Sishayela lapha inani elilandelayo: "DDDD". Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

4. Ilungile! Ngenxa yalokho, senze ukuthi usuku esitokisini setafula luguquke lwaba igama lesonto. Khetha leli seli ngokucindezela inkinobho yegundane kwesokunxele bese ubheka umugqa wokufaka amafomula. Idethi yoqobo ngokwayo iboniswa lapha.

Kubalulekile! Ungashintsha inani elithi “DDDD” libe “DDDD”. Ngenxa yalokho, usuku luzovezwa kuseli ngendlela efushanisiwe. Ukuhlola kuqala kungenziwa efasiteleni lokuhlela emugqeni obizwa ngokuthi “Isampula”.

Kusetshenziswa umsebenzi we-TEXT ukucacisa usuku lweviki

Indlela engenhla ingena esikhundleni sosuku kuseli yethebula elikhethiwe ngegama losuku lweviki. Le ndlela ayizifanele zonke izinhlobo zemisebenzi exazululwe kusipredishithi se-Excel. Ngokuvamile abasebenzisi badinga ukwenza usuku lweviki kanye nedethi kuvele kumaseli ahlukene. Umsebenzisi okhethekile obizwa nge-TEXT ikuvumela ukuthi usebenzise le nqubo. Ake sibheke udaba ngokuningiliziwe. Ukuhamba:

1. Isibonelo, kuthebhulethi yethu kunedethi ethile. Ekuqaleni, sikhetha iseli lapho sifuna ukubonisa khona igama losuku lweviki. Senza ukukhetha kweseli ngokucindezela inkinobho yegundane kwesokunxele. Sichofoza inkinobho ethi "Faka Umsebenzi" eseduze komugqa wokufaka amafomula.

2. Iwindi elincane elibizwa ngokuthi “Faka Umsebenzi” liboniswe esikrinini. Nweba uhlu eduze nombhalo othi "Isigaba:". Ohlwini oludonsela phansi, khetha into ethi "Umbhalo".

3. Efasiteleni elithi “Khetha umsebenzi:” sithola u-opharetha othi “TEXT” bese uchofoza kuso ngenkinobho yegundane engakwesokunxele. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK" etholakala phansi kwefasitela.

4. Iwindi liyavela esibukweni lapho kufanele ufake khona izimpikiswano zoopharetha. Ukubuka okujwayelekile komsebenzisi: =TEXT(Inani;Ifomethi Yokukhiphayo). Kunezimpikiswano ezimbili okufanele zigcwalise lapha. Emugqeni othi “Value” kufanele ufake idethi, usuku lweviki esihlele ukulibonisa. Ungakwazi ukwenza le nqubo ngokwakho ngokuyifaka mathupha noma ngokucacisa ikheli leseli. Chofoza umugqa ukuze uthole isethi yamanani, bese uchofoza i-LMB kuseli edingekayo enosuku. Emgqeni othi "Ifomethi" sishayela ngohlobo oludingekayo lokuphuma kosuku lwesonto. Khumbula ukuthi i-“DDDD” isibonisi esigcwele segama, futhi i-“DDD” isifushaniso. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK" etholakala phansi kwefasitela.

5. Ekugcineni, iseli elinefomula efakiwe izobonisa usuku lweviki, futhi idethi yokuqala izohlala kweyangempela.

6. Kubalulekile ukuqaphela ukuthi ukuhlela idethi kuzoshintsha ngokuzenzakalelayo usuku lweviki kuseli. Lesi sici sisebenziseka kalula.

Kusetshenziswa umsebenzi WEEKDAY ukucacisa usuku lweviki

Umsebenzi WEEKDAY ungomunye u-opharetha okhethekile wokufeza lo msebenzi. Qaphela ukuthi ukusetshenziswa kwalo opharetha kusho ukuboniswa hhayi kwegama losuku lweviki, kodwa inombolo yomkhiqizo. Ngaphezu kwalokho, ngokwesibonelo, uLwesibili akudingeki kube inombolo 2, njengoba uhlelo lwezinombolo lusethwa umsebenzisi wespredishithi ngokwakhe. Ukuhamba:

1. Isibonelo, sineseli elinedethi ebhaliwe. Sichofoza kunoma iyiphi enye iseli lapho sihlela ukubonisa umphumela woshintsho. Sichofoza inkinobho ethi "Faka Umsebenzi" etholakala eduze komugqa wokufaka amafomula.

2. Iwindi elincane elithi “Faka Umsebenzi” liboniswe esikrinini. Nweba uhlu eduze nombhalo othi "Isigaba:". Kuyo, chofoza into ethi "Idethi nesikhathi". Efasiteleni elithi “Khetha umsebenzi:,” thola “USUKU LWEVIKI” bese uchofoza kulo nge-LMB. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK" etholakala phansi kwefasitela.

3. Iwindi livela esibukweni lapho kufanele ufake khona amanani opharetha. Ukubuka okujwayelekile komsebenzisi: =USUKUWEEK(usuku, [uhlobo]). Kunezimpikiswano ezimbili okufanele zigcwalise lapha. Emgqeni othi "Idethi" faka usuku oludingekayo noma shayela ekhelini lensimu. Emgqeni othi "Thayipha" sifaka usuku lapho i-oda lizoqala ngalo. Kunamanani amathathu ale mpikiswano ongakhetha kuwo. Inani "1" - i-oda liqala ngeSonto. Inani lingu-“2” - usuku loku-1 kuzoba uMsombuluko. Inani "3" - usuku loku-1 luzophinda lube uMsombuluko, kodwa inombolo yalo izolingana no-zero. Faka inani elithi “2” emgqeni. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

Nakani! Uma umsebenzisi engagcwalisi lo mugqa nganoma yiluphi ulwazi, khona-ke okuthi “Uhlobo” kuzothatha ngokuzenzakalelayo inani elithi “1”.

4. Kuleli seli eno-opharetha, umphumela uboniswe ngenombolo, ehambisana nosuku lweviki. Esibonelweni sethu, lokhu kunguLwesihlanu, ngakho lolu suku lwabelwa inombolo "5".

5. Kubalulekile ukuqaphela ukuthi ukuhlela idethi kuzoshintsha ngokuzenzakalelayo usuku lweviki kuseli.

Isiphetho nesiphetho mayelana nezindlela ezicatshangelwayo

Sicabangele izindlela ezintathu zokubonisa usuku lweviki ngedethi kuspredishithi. Indlela ngayinye ilula kakhulu ukuyisebenzisa futhi ayidingi amakhono engeziwe. Indlela yesibili ecatshangelwayo ilula kakhulu, njengoba isebenzisa okukhipha idatha kuseli elihlukile ngaphandle kokushintsha ulwazi lwangempela nganoma iyiphi indlela.