Kufananiza masiku mu Excel

Nthawi zambiri, ogwiritsa ntchito mkonzi wa spreadsheet amafunika kuchita zovuta monga kufananiza masiku. Izi zitha kuchitika m'njira zosiyanasiyana. M'nkhaniyi, tidzasanthula mwatsatanetsatane njira zonse zomwe zimakulolani kufananitsa madeti mumkonzi wa spreadsheet.

Kukonza nthawi mumkonzi wa spreadsheet

Mkonzi wa spreadsheet amawona nthawi ndi tsiku ngati nambala. Pulogalamuyi imatembenuza chidziwitsochi m'njira yakuti tsiku limodzi likhale lofanana ndi 1. Zotsatira zake, chizindikiro cha nthawi ndi gawo limodzi. Mwachitsanzo, 12.00 ndi 0.5. Mkonzi wa spreadsheet amasintha zizindikiro za tsiku kukhala nambala, yomwe ili yofanana ndi chiwerengero cha masiku kuyambira January 1, 1900 mpaka tsiku lotchulidwa. Mwachitsanzo, ngati wogwiritsa ntchito atembenuza tsiku 14.04.1987/31881/31881, ndiye kuti lidzakhala ndi mtengo wa 2. Mwa kuyankhula kwina, masiku XNUMX adutsa chizindikiro choyambirira. Makinawa amagwiritsidwa ntchito powerengera nthawi. Kuti muwerenge kuchuluka kwa masiku pakati pa masiku XNUMX, m'pofunika kuchotsa chizindikiro chaching'ono pa nthawi yokulirapo.

Pogwiritsa ntchito mawu a DATE mumkonzi wa tebulo

Mawonekedwe a opareshoni amawoneka motere: DATE(chaka, mwezi, tsiku). Mkangano uliwonse uyenera kulembedwa mwa woyendetsa. Pali njira ziwiri zokhazikitsira mkangano. Njira yoyamba imaphatikizapo kulowetsamo manambala mwachizolowezi. Njira yachiwiri imaphatikizapo kulowa m'magulu a maselo omwe chidziwitso chofunikira cha nambala chilipo. Mtsutso woyamba ndi nambala kuyambira 1900 mpaka 9999. Mtsutso wachiwiri ndi nambala kuyambira 1 mpaka 12. Mtsutso wachitatu ndi nambala kuyambira 1 mpaka 31.

Mwachitsanzo, ngati mutchula mtengo wokulirapo kuposa 31 ngati tsiku, ndiye kuti tsiku lowonjezera lidzasunthira mwezi wina. Ngati wosuta alowa masiku makumi atatu ndi awiri mu Marichi, adzatha ndi woyamba wa Epulo.

Chitsanzo cha ogwiritsa ntchito chikuwoneka motere:

Chitsanzo chofotokozera kuchuluka kwa masiku mu June:

Chitsanzo chosonyeza kugwiritsa ntchito ma cell coordinates ngati mfundo:

Kugwiritsa ntchito RAZDAT mu mkonzi wa spreadsheet

Wogwiritsa ntchitoyu amabweza pakati pa masiku awiri. Mawonekedwe a opareshoni amawoneka motere: RAZDAT(tsiku_loyamba; tsiku_lomaliza; code_for_designation_of_count_units). Mitundu ya mawerengedwe apakati pakati pa zizindikiro za masiku awiri:

• "d" - amasonyeza chizindikiro chomaliza m'masiku;
• "m" - amawonetsa kuchuluka kwa miyezi;
• "y" - amawonetsa kuchuluka kwazaka;
• "ym" - amawonetsa kuchuluka kwa miyezi, osaphatikiza zaka;
• "md" - amawonetsa masiku onse, osaphatikizapo zaka ndi miyezi;
• "yd" - amawonetsa kuchuluka kwa masiku, osaphatikiza zaka.

M'matembenuzidwe ena a spreadsheet editor, mukamagwiritsa ntchito mikangano yowonjezereka ya 2, wogwiritsa ntchito akhoza kusonyeza cholakwika. Pankhaniyi, ndi bwino kugwiritsa ntchito njira zina.

Chitsanzo chosonyeza ntchito ya opareshoni:

Mu mkonzi wa spreadsheet wa 2007, wogwiritsa ntchito uyu sali muzofotokozera, koma mutha kuzigwiritsabe ntchito.

Kugwiritsa ntchito YEAR mumkonzi wa spreadsheet

Wogwiritsa ntchitoyu amakulolani kubweza chaka ngati chiwerengero chokwanira chogwirizana ndi tsiku lotchulidwa. Nambala ya nambala ikuwonetsedwa kuyambira 1900 mpaka 9999. Mtundu wamba wa YEAR wogwiritsa ntchito ali ndi mtsutso umodzi. Mtsutso ndi tsiku la nambala. Iyenera kulembedwa pogwiritsa ntchito DATE, kapena kutulutsa chizindikiro chomaliza cha mawerengedwe amitundu ina iliyonse. Chitsanzo chosonyeza ntchito ya opareshoni:

Kugwiritsa ntchito MONTH wogwiritsa ntchito spreadsheet

Wogwiritsa ntchitoyu amakulolani kubweza mweziwo ngati mtengo wathunthu wolingana ndi tsiku lotchulidwa. Nambala ya nambala ikuwonetsedwa kuyambira 1 mpaka 12. Mtundu wamba wa MONTH wogwiritsa ntchito uli ndi mtsutso umodzi. Mtsutso ndi tsiku la mwezi, lolembedwa ngati nambala. Iyenera kulembedwa pogwiritsa ntchito DATE, kapena kutulutsa chizindikiro chomaliza cha mawerengedwe amitundu ina iliyonse. Ndikoyenera kudziwa kuti mwezi wolembedwa m'mawu olembedwa sudzasinthidwa bwino ndi mkonzi wa spreadsheet. Chitsanzo chosonyeza ntchito ya opareshoni:

Zitsanzo zogwiritsa ntchito DAY, WEEKDAY, ndi WEEKDAY mumkonzi wa spreadsheet

Wogwiritsa ntchitoyu amakulolani kuti mubweze tsikulo ngati mtengo wathunthu wolingana ndi tsiku lotchulidwa. Nambala ikuwonetsedwa kuyambira 1 mpaka 31. Mawonekedwe a DAY ogwiritsira ntchito ali ndi mtsutso umodzi. Mtsutso ndi tsiku la tsikulo, lolembedwa ngati nambala yamtengo wapatali. Iyenera kulembedwa pogwiritsa ntchito DATE, kapena kutulutsa chizindikiro chomaliza cha mawerengedwe amitundu ina iliyonse. Chitsanzo chosonyeza ntchito ya opareshoni:

Wothandizira, yemwe ali ndi dzina la WEEKDAY, amakulolani kubweza nambala ya tsiku la sabata la tsiku lomwe mwapatsidwa. Mwachikhazikitso, wogwiritsa ntchito amawona Lamlungu ngati tsiku loyamba la sabata. Chitsanzo chosonyeza ntchito ya opareshoni:

Wothandizira, yemwe ali ndi dzina la NOMWEEK, amakulolani kuti muwonetse nambala ya ordinal ya sabata mu tsiku loperekedwa. Chitsanzo chosonyeza ntchito ya opareshoni:

Mwachitsanzo, May 24.05.2015, XNUMX ndi sabata la makumi awiri ndichiwiri la chaka. Monga momwe zinalembedwera pamwambapa, pulogalamuyo imawona Lamlungu ngati tsiku loyamba la sabata.

Mtsutso wachiwiri ndi 2. Izi zimalola mkonzi wa spreadsheet kuganizira Lolemba ngati chiyambi cha sabata (pokhapokha mkati mwa ndondomekoyi).

TODAY wogwiritsa ntchito amagwiritsidwa ntchito kuyika tsiku lomwe lilipo. Wothandizira uyu alibe zotsutsana. Wogwiritsa TDATE () amagwiritsidwa ntchito kusonyeza tsiku ndi nthawi yomwe ilipo.

Mapeto ndi zomaliza za kufananiza masiku mumkonzi wa spreadsheet

Tinapeza kuti pali njira zambiri ndi ogwira ntchito kufananitsa madeti awiri mumkonzi wa spreadsheet. Njira yodziwika kwambiri ndikugwiritsa ntchito RAZNDATA, yomwe imakulolani kuti mubwererenso kusiyana pakati pa masiku awiri. Kuphatikiza apo, mutha kugwiritsa ntchito njira zofananira kuti mubwezere matsiku, mwezi, ndi chaka. Wogwiritsa ntchito aliyense akhoza kusankha yekha njira yabwino kwambiri yofananizira masiku mumkonzi wa spreadsheet.