Momwe mungadziwire tsiku la sabata kuyambira tsiku mu Excel

Nthawi zambiri, ogwiritsa ntchito spreadsheet ya Excel amafunika kuchitapo kanthu monga kuwonetsa dzina la tsiku la sabata lolingana ndi selo linalake. Excel ili ndi ntchito zingapo zomwe zimakulolani kuti mugwiritse ntchito njirayi. M'nkhaniyi, tikambirana mwatsatanetsatane njira zingapo zowonetsera bwino tsiku la sabata ndi tsiku.

Kuwonetsa tsiku la sabata pogwiritsa ntchito mawonekedwe a cell

Chinthu chachikulu cha njirayi ndi chakuti panthawi yogwiritsira ntchito njira yokhayo yomaliza idzawonetsedwa kusonyeza tsiku la sabata. Tsiku lenilenilo silidzawonetsedwa, mwa kuyankhula kwina, tsiku lomwe lili m'munda lidzatenga tsiku lofunidwa la sabata. Tsiku lidzawonekera pamzere wa fomula yokhazikitsidwa pomwe selo lasankhidwa. Kuyenda:

1. Mwachitsanzo, tili ndi tabuleti yosonyeza tsiku lenileni.

2. Dinani kumanja pa selo ili. Menyu yaying'ono yankhani idawonetsedwa pazenera. Timapeza chinthu chotchedwa "Format Cells ..." ndikudina ndi batani lakumanzere.

3. Tinamaliza pa zenera lotchedwa "Format Maselo". Timapita ku gawo la "Nambala". Pamndandanda waung'ono "Mawonekedwe a Nambala" sankhani chinthucho "(mitundu yonse)". Timayang'ana mawu akuti "Mtundu:". Dinani batani lakumanzere la mbewa pagawo lolowetsa lomwe lili pansipa mawu awa. Timayendetsa apa mtengo wotsatira: "DDDD". Pambuyo pochita zosintha zonse, dinani "Chabwino".

4. Okonzeka! Zotsatira zake, tinapanga kuti tsiku lomwe lili mu cell cell lisinthe kukhala dzina la sabata. Sankhani cell iyi podina batani lakumanzere la mbewa ndikuyang'ana pamzere wolowetsa mafomu. Tsiku loyambirira lokha likuwonetsedwa pano.

Zofunika! Mutha kusintha mtengo wa "DDDD" kukhala "DDDD". Zotsatira zake, tsikulo lidzawonetsedwa mu cell mu mawonekedwe achidule. Kuwoneratu kutha kuchitika pazenera losintha pamzere wotchedwa "Sample".

Kugwiritsa ntchito TEXT kudziwa tsiku la sabata

Njira yomwe ili pamwambayi imalowa m'malo mwa deti la tebulo losankhidwa ndi dzina la tsiku la sabata. Njira iyi si yoyenera pamitundu yonse ya ntchito zomwe zathetsedwa mu Excel spreadsheet. Nthawi zambiri ogwiritsa ntchito amafunika kupanga tsiku la sabata komanso tsiku liwonekere m'maselo osiyanasiyana. Wogwiritsa ntchito wapadera wotchedwa TEXT amakulolani kuti mugwiritse ntchito njirayi. Tiyeni tione nkhaniyi mwatsatanetsatane. Kuyenda:

1. Mwachitsanzo, m’tabuleti yathu muli deti lenileni. Poyamba, timasankha selo limene tikufuna kusonyeza dzina la tsiku la sabata. Timagwiritsa ntchito kusankha kwa ma cell podina batani lakumanzere. Timadina batani la "Insert Function" lomwe lili pafupi ndi mzere wolowetsa mafomu.

2. Zenera laling'ono lotchedwa "Insert Function" linawonetsedwa pazenera. Wonjezerani mndandanda pafupi ndi mawu akuti "Category:". Pamndandanda wotsitsa, sankhani chinthu cha "Text".

3. Pazenera "Sankhani ntchito:" timapeza woyendetsa "TEXT" ndikudina ndi batani lakumanzere. Pambuyo pochita zosintha zonse, dinani batani la "Chabwino" lomwe lili pansi pawindo.

4. Iwindo likuwonekera pawonetsero lomwe muyenera kuyikamo zotsutsana za opareshoni. Maonedwe onse a wogwiritsa ntchito: =TEXT(Mtengo;Zotulutsa). Pali mikangano iwiri yoti mudzaze apa. Pamzere wa "Value" muyenera kuyika tsiku, tsiku la sabata lomwe tikufuna kuwonetsa. Mutha kuchita izi nokha polowetsa pamanja kapena kutchula adilesi ya foni. Dinani pamzere kuti mupeze mndandanda wazinthu, ndiyeno dinani LMB pa selo yofunikira ndi tsiku. Mu mzere "Format" timayendetsa mumtundu wofunikira wa tsiku la sabata. Kumbukirani kuti "DDDD" ndi chiwonetsero chonse cha dzina, ndipo "DDD" ndi chidule. Pambuyo pochita zosintha zonse, dinani batani la "Chabwino" lomwe lili pansi pawindo.

5. Pamapeto pake, selo lomwe lili ndi fomula lomwe lalowetsedwa liwonetsa tsiku la sabata, ndipo tsiku loyambirira likhalabe loyambirira.

6. Ndizofunikira kudziwa kuti kusintha tsikulo kumangosintha tsiku la sabata mu cell. Mbali imeneyi ndi yosavuta kugwiritsa ntchito.

Kugwiritsa ntchito WEEKDAY kudziwa tsiku la sabata

Ntchito ya WEEKDAY ndi wogwiritsa ntchito wina wapadera kuti akwaniritse ntchitoyi. Zindikirani kuti kugwiritsa ntchito opareshoni kumatanthauza kuwonetsa osati dzina la tsiku la sabata, koma nambala ya serial. Komanso, mwachitsanzo, Lachiwiri siliyenera kukhala nambala 2, popeza dongosolo la manambala limayikidwa ndi wogwiritsa ntchito spreadsheet. Kuyenda:

1. Mwachitsanzo, tili ndi selo yokhala ndi deti lolembedwa. Timadina pa selo lina lililonse limene tikukonzekera kusonyeza zotsatira za kusintha. Timadina batani la "Insert Function" lomwe lili pafupi ndi mzere wolowetsa mafomu.

2. Zenera laling'ono la "Insert Function" linawonetsedwa pazenera. Wonjezerani mndandanda pafupi ndi mawu akuti "Category:". Mmenemo, dinani "Tsiku ndi Nthawi". Pazenera la "Sankhani ntchito," pezani "WEEK DAY" ndikudina ndi LMB. Pambuyo pochita zosintha zonse, dinani batani la "Chabwino" lomwe lili pansi pawindo.

3. Zenera likuwonekera pachiwonetsero chomwe muyenera kuyikamo zomwe wogwiritsa ntchitoyo ali nazo. Maonedwe onse a wogwiritsa ntchito: =TSIKU(TSIKU, [mtundu]). Pali mikangano iwiri yoti mudzaze apa. Mu mzere "Tsiku" lowetsani tsiku lofunika kapena kuyendetsa mu adilesi yamunda. Mu mzere wa "Mtundu" timalowetsa tsiku lomwe dongosolo lidzayamba. Pali zinthu zitatu zomwe mungasankhe. Mtengo "1" - dongosolo limayamba kuyambira Lamlungu. Mtengo ndi "2" - tsiku la 1 lidzakhala Lolemba. Mtengo "3" - tsiku loyamba lidzakhalanso Lolemba, koma chiwerengero chake chidzakhala chofanana ndi ziro. Lowetsani mtengo "1" pamzere. Pambuyo pochita zosintha zonse, dinani "Chabwino".

Tcherani khutu! Ngati wosuta sadzaza mzerewu ndi chidziwitso chilichonse, ndiye kuti "Mtundu" utenga mtengo wa "1".

4. Mu cell iyi yokhala ndi woyendetsa, zotsatira zake zidawonetsedwa mu manambala, omwe amafanana ndi tsiku la sabata. Mu chitsanzo chathu, ili ndi Lachisanu, kotero tsikuli linapatsidwa nambala "5".

5. Ndizofunikira kudziwa kuti kusintha tsikulo kumangosintha tsiku la sabata mu cell.

Zomaliza ndi zomaliza za njira zomwe zaganiziridwa

Takambirana njira zitatu zowonetsera tsiku la sabata ndi tsiku mu spreadsheet. Njira iliyonse ndi yosavuta kugwiritsa ntchito ndipo safuna luso lina lililonse. Njira yachiwiri yomwe imaganiziridwa ndi yosavuta kwambiri, chifukwa imagwiritsa ntchito kutulutsa kwa data mu selo linalake popanda kusintha chidziwitso choyambirira mwanjira iliyonse.