Zolepheretsa Tsiku Lotsutsa mu Mafomu pogwiritsa ntchito DATE Ntchito
Madeti ndi DATE Ntchito Ntchito mwachidule
Ntchito ya Google Spreadsheet ya DATE idzabweretsanso tsiku kapena nambala yeniyeni ya tsiku mwa kuphatikiza tsiku lirilonse, mwezi ndi chaka zomwe zimalowa monga zokhudzana ndi ntchito.
Mwachitsanzo, ngati DATE yotsatira ikugwira ntchito mu selo lamasamba,
= DATE (2016,01,16)
nambala 42385 yatsatiridwa , yomwe imatanthawuza tsiku la January 16, 2016.
Kusintha Mndandanda wa Mndandanda ku Dates
Zikadzalowa zokha - monga momwe zasonyezedwera mu selo D4 mu chithunzi pamwambapa, nambala yapadera imakhala yojambulidwa kuti iwonetse tsikulo. Masitepe oyenera kuti akwaniritse ntchitoyi alembedwa m'munsimu ngati pakufunika.
Kulowa Mwezi monga Nthawi
Pogwirizana ndi zina Google Spreadsheet, DATE ingagwiritsidwe ntchito kupanga mitundu yosiyanasiyana ya maulendo monga momwe tawonetsera pa chithunzi pamwambapa.
Ntchito imodzi yogwiritsira ntchito - monga momwe ikuwonetsera mzere 5 mpaka 10 mu chithunzi pamwambapa - ndikuonetsetsa kuti masiku amalowa ndi kutanthauziridwa molondola ndi zina za Google Spreadsheet ntchito zina za tsiku. Izi ndizowona makamaka ngati deta yolembedwera imapangidwanso ngati malemba.
Ntchito ya DATE imagwiritsidwa ntchito makamaka:
- kusonyeza tsiku limene limaphatikizapo zinthu zakuthambo - monga chaka, mwezi, kapena tsiku kuchokera kumadera osiyanasiyana pa tsamba
- kuonetsetsa kuti masiku ogwiritsidwa ntchito powerengetsera amatanthauzidwa ngati masiku (chiwerengero cha deta) m'malo molemba deta
DATE Ntchito & # 39; s Syntax ndi Arguments
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa.
Chidule cha DATE ntchito ndi:
= DATE (chaka, mwezi, tsiku)
chaka - (chofunika) lowetsani chaka ngati nambala yaiyi (yyyy) kapena selo loyang'ana malo ake pa tsamba
mwezi - (zofunikira) lowetsani mweziwu ngati nambala ya chiwerengero (mm) kapena mawonekedwe a selo kumalo ake olembedwa
tsiku - (zofunikira) lowetsani tsiku ngati nambala ziwiri (dd) kapena mawonekedwe a selo kumalo ake
- #VALUE! Ndalama yamakono imabweretsedwa ndi ntchito ngati deta yanu imalowa m'malo mwa nambala - izi zimaphatikizapo kulowetsa ma selo lokhala ndi malemba
- #NUM! Ndalama yamabvuto imabweretsedwanso ndi ntchito ngati nambala zisanu nambala - monga 20016 - yalowa mkangano wa chaka
- ngati mtengo wosafunika wa mwezi kapena usana, zintchito zimangosintha zotsatira za ntchitoyo ku tsiku lovomerezeka. Mwachitsanzo,
- = DATE (2016,13,1) - yomwe ili ndi 13 pampikisano wamwezi - imasintha mtsutso wa chaka ndikubwerera 1/1/2017
- = DATE (2016,01,32) - yomwe ili ndi masiku 32 kwa mwezi wa Januwale - ikuthandizani kutsutsana kwa mwezi ndikubwezeretsa 2/01/2016
- ngati mfundo zamtengo wapatali zalowa muzitsutsano, mtengowo umadulidwa ku mtengo wapatali. Mwachitsanzo, mtengo "10.25" ungatembenuzidwe ngati "10" ndi ntchitoyi
DATE Chitsanzo Chitsanzo
Mu chithunzi pamwambapa, ntchito ya DATE imagwiritsidwa ntchito mogwirizana ndi ntchito zina zingapo m'mafomu a tsiku.
Mafomu omwe adatchulidwawa ndiwo chitsanzo cha ntchito ya DATE. Njirayi mu:
- Mzere 5 umalowa tsiku loyamba la mwezi wamakono;
- Mzere 6 umatembenuza chingwe (selo A5) mu tsiku;
- Mzere 7 ukuwonetsera tsiku la sabata pa tsiku lopereka;
- Mzere 8 umakhala masiku pakati pa masiku amasiku ano ndi apitawo;
- Mzere 9 umasintha Yulian Day Number (selo A9) mpaka lero;
- Mzere 10 umatembenuza tsiku lomwelo (selo A10) ku Nambala ya Tsiku la Julian.
Zomwe zili pansipa zikukhudza njira zomwe zingagwiritsidwe ntchito mu DATE ntchito yomwe ili mu selo B4. Zomwe zimagwira ntchitoyi zikuwonetseratu tsiku lopangidwa ndi kuphatikiza zochitika za tsiku zomwe zili m'maselo A2 mpaka C2.
Kulowa DATE Ntchito
Zosankha zolowera ntchitoyi ndi zifukwa zake muzomwe zimaphatikizapo ndi:
1) Kulemba mwachindunji ntchito yonse - kumbukirani kuti dongosolo liyenera kukhala yyyy, mm, d , monga:
= DATE (2016,01,16) kapena,
= DATE (A2, B2, C2) ngati mukugwiritsa ntchito ma selo
2) Pogwiritsa ntchito bokosi lopangira mothandizidwa kuti alowe ntchitoyi ndi zifukwa zake
Google spreadsheets sagwiritsira ntchito bokosi la dialogs kuti mulowetse malingaliro a ntchito monga angapezeke mu Excel. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo.
Osiyanitsa Komma
Mukamagwiritsira ntchito njira imodzi kuti mulowemo ntchito, onetsetsani kuti makasitomala ( , ) amagwiritsidwa ntchito polekanitsa zokhudzana ndi ntchito mkati mwa mabwalo oyandikana.
Masitepe omwe ali m'munsimu akuthandizira momwe mungaloweretse DATE ntchito yomwe ili mu selo B4 mu chithunzi pamwambapa pogwiritsa ntchito bokosi lopangira okhaokha.
- Dinani pa selo D4 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za DATE ntchito zidzawonetsedwa
- Lembani chizindikiro chofanana (=) chotsatira dzina la ntchito - tsiku
- Pamene mukuyimira, bokosi lopangira mothandizilo likuwoneka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata D
- Pamene DATE ikuwonekera mu bokosi, dinani pa dzina ndi ndondomeko ya mouse kuti mulowetse dzina la ntchito ndi kutsegula makina ozungulira mu selo D4
- Dinani pa selo A2 mu tsamba lothandizira kuti mulowetse mndandanda wa seloyi ngati mkangano wa chaka
- Pambuyo powerenga selo, tanizani comma ( , ) kuti mukhale olekanitsa pakati pa zotsutsana
- Dinani pa selo B2 kuti mulowetse selo ili ngati kutsutsana kwa mwezi
- Pambuyo pa selo yowonjezera, yesani mtundu wina
- Dinani pa selo C2 kuti mulowetse selo ili ngati kutsutsana kwa tsiku
- Lembani mzere wolowera mu kiyikilo kuti mulowe m'bokosi lomaliza " ) " ndi kumaliza ntchitoyi
- Tsikuli liyenera kuoneka mu selo B1 mu 11/15/2015
- Mukasindikiza pa selo B1 ntchito yonse = DATE (A2, B2, C2) ikuwoneka mu barra ya fomu pamwamba pa tsamba
Zindikirani : ngati zotsatira zomwe zili mu selo B4 sizolondola mukatha kulowa ntchitoyi, nkotheka kuti seloyo imasankhidwa molakwika. M'munsimu muli ndondomeko zotsatila kusintha kusintha kwa tsiku.
Kusintha mtundu wa Date
Kusintha ku fomu yamakono mu Google Spreadsheets
- Onetsetsani maselo omwe ali pa tsamba limene muli kapena ali ndi masiku
- Dinani pa Fomu> Nambala> Tsiku m'masewera kuti musinthe mawonekedwe a selo kumtundu wamtundu womwe umagwiritsidwa ntchito ndi zochitika zamakono - onani m'munsimu kuti musinthe mawonekedwe a chigawo.
Zosintha Zachigawo
Mofanana ndi mapulogalamu ambiri a pa intaneti, Google Spreadsheets imasokoneza mtundu wa American date - womwe umatchedwanso Medidian-MM / DD / YYYY.
Ngati malo anu amagwiritsa ntchito fomu yamtundu wina - monga big-endian (YYYY / MM / DD) kapena Google -Spansheets (DD / MM / YYYY) yaing'ono ingasinthidwe kuti asonyeze tsikulo mwa njira yoyenera pakukonza zosintha za m'deralo .
Kusintha zochitika za m'deralo:
- Dinani Fayilo kuti mutsegule Fayilo menu;
- Dinani pa zolemba za Spreadsheet ... kuti mutsegule dialog dialog Settings ;
- Pansi pa malo mu bokosi la bokosi, dinani pa bokosi - mtengo wapatali wa United States - kuti muwone mndandanda wa zochitika za dziko;
- Dinani pa dziko lanu labwino kuti mupange chisankho chamakono;
- Dinani Pulogalamu yosungira pansi pa bokosi la bokosi kuti mutsekeze ndi kubwerera ku tsamba la ntchito;
- Mawatsopano atsopano amapangidwa mu tsamba loyenera ayenera kutsatira momwe dziko losankhidwira - maulendo omwe alipo alipo angafunike kukonzedwanso kuti kusinthaku kuchitike.
Zithunzi Zosasokoneza ndi Zotsatira za Excel
Mwachindunji, Microsoft Excel ya Windows imagwiritsa ntchito dongosolo lasuku lomwe limayamba m'chaka cha 1900. Kulowa nambala ya serie ya 0 imabweretsanso tsiku: January 0, 1900. Kuwonjezera apo, ntchito ya Excel ya DATE siidzawonetsera masiku isanafike 1900.
Google Spreadsheets imagwiritsa ntchito tsiku la December 30, 1899 kuti likhale nambala ya zero, koma mosiyana ndi Excel, Google Spreadsheets imawonetsera masiku asanafike izi pogwiritsa ntchito manambala osasintha a nambala yotsatira.
Mwachitsanzo, tsiku la January 1, 1800 limapereka chiwerengero cha -36522 mu Google Spreadsheets ndikuloleza kugwiritsa ntchito mwa njira, monga kuchotsa January 1, 1850 - January 1, 1800 zomwe zimapangitsa mtengo wa 18, 262 - nambala ya masiku pakati pa masiku awiriwo.
Tsiku lomwelo litalowa mu Excel, komabe pulogalamuyo imasintha tsikulo kuti lilembetse deta ndikubwezeretsa #VALUE! zolakwika ngati tsikulo likugwiritsidwa ntchito muchitidwe.
Numeri ya Tsiku la Julian
Numeri ya Tsiku la Julian, monga yogwiritsidwa ntchito ndi mabungwe ambiri a boma ndi mabungwe ena, ndi manambala omwe amaimira chaka ndi tsiku. Kutalika kwa manambalawa kumasiyanasiyana malinga ndi kuchuluka kwa manambala omwe amagwiritsidwa ntchito kuimira chaka ndi tsiku zigawo za nambalayi.
Mwachitsanzo, mu chithunzi pamwambapa, chiwerengero cha Julian Day mu selo A9 - 2016007 - ndi maulendo asanu ndi awiri omwe ali ndi ziwerengero zoyamba za chiwerengerocho zikuyimira chaka ndi zitatu zotsiriza tsiku la chaka. Monga momwe tawonetsera mu selo B9, nambala iyi ikuimira tsiku lachisanu ndi chiwiri la chaka cha 2016 kapena la 7 January, 2016.
Mofananamo, nambala ya 2010345 ikuimira tsiku la 345 la chaka cha 2010 kapena la 11 December 2010.