Amaphutha Wosuku Lokuvimbela Ngamafomu usebenzisa umsebenzi we-DATE
Izinsuku kanye no-DATE Umsebenzi Wokubuka
Umsebenzi we-Google Spreadsheet umsebenzi we-DATE uzobuyisela usuku noma inombolo ye - serial yosuku ngokuhlanganisa usuku ngalunye, izinyanga nezinyanga ezifakiwe njengezingqinamba zomsebenzi.
Isibonelo, uma umsebenzi olandelayo we-DATE ufakwe kuseli lokusebenzela,
= DATE (2016,01,16)
inombolo ye-serial 42385 ibuyiselwe, okubhekisela kulolu suku ngoJanuwari 16, 2016.
Ukuguqula Izinombolo Zenombolo kuya Ezikhathini
Uma kungenwe yedwa - njengoba kuboniswe esitokisini D4 esithombeni ngenhla, inombolo ye-serial ngokuvamile ifomathiwe ukubonisa usuku. Izinyathelo ezidingekayo ukufeza lo msebenzi zibalwe ngezansi uma kudingeka.
Ukufaka izinsuku njengezikhathi
Uma kuhlangene nezinye imisebenzi ye- Google Spreadsheet, i-DATE ingasetshenziselwa ukukhiqiza amafomula amaningi ahlukahlukene njengoba kuboniswa esithombeni ngenhla.
Ukusetshenziswa okubalulekile komsebenzi - njengoba kuboniswe emigqeni engu-5 kuya ku-10 esithombeni ngenhla - ukuqinisekisa ukuthi izinsuku zifakiwe futhi zihunyushwe kahle ngezinye zezinsuku zomsebenzi we-Google Spreadsheet. Lokhu kuyiqiniso ikakhulu uma idatha efakwe ifomathiwe njengombhalo.
Umsebenzi we-DATE usetshenziswa ngokuyinhloko:
- ukubonisa usuku oluhlanganisa izakhi zesikhathi - njengonyaka, inyanga, noma usuku ezivela ezindaweni ezihlukene kushidi lokusebenzela
- ukuqinisekisa ukuthi izinsuku ezisetshenziselwa ukubalwa zihunyushwa njengezinsuku (idatha yocingo) esikhundleni sokubhala idatha
I-DATE Umsebenzi & # 39; s i-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana.
I-syntax yomsebenzi we-DATE yile:
= DATE (unyaka, inyanga, usuku)
unyaka - (edingekayo) faka unyaka njengezinombolo ezine zamadijithali (yyyy) noma ireferensi yeseli endaweni yayo kuphepha lokusebenzela
inyanga - (edingekayo) faka inyanga njengezinombolo ezimbili zamamitha (mm) noma ireferensi yeseli endaweni yayo ekhasini lokusebenzela
usuku - (oludingekayo) faka usuku njengezinombolo ezimbili zamadijithi (dd) noma ireferensi yeseli endaweni yayo ekhasini lokusebenzela
- i-#VALUE! inani lephutha libuyiselwa umsebenzi uma idatha yombhalo efakwe esikhundleni senombolo - lokhu kuhlanganisa ukufaka ireferensi yeseli equkethe umbhalo
- #NUM! inani lephutha libuyiselwa umsebenzi uma inombolo yezinombolo eziyisihlanu - njenge-20016 - ingenwe ngxabano yonyaka
- uma inani elingavumelekile lenyanga noma iziphakamiso zosuku, umsebenzi ulungisa ngokuzenzakalelayo ukukhishwa komsebenzi osukwini oluzayo oluvumelekile. Ngokwesibonelo,
- = DATE (2016,13,1) - enama-13 ephikisana nenyanga - ilungisa impikiswano yonyaka futhi ibuyele ngo-1/1/2017
- = DATE (2016,01,32) - enezinsuku ezingu-32 ngenyanga kaJanuwari - ilungisa ingxabano yenyanga iphinde ibuyele ngo-2/01/2016
- uma ama-decimal decimal afakwe engxabano, inani lihanjiswe inani lenani eliphelele. Isibonelo, inani "10.25" lizohunyushwa ngokuthi "10" ngomsebenzi
DATE Isibonelo somsebenzi
Esikhathini esingenhla, umsebenzi we-DATE usetshenziselwa ngokuhlanganyela neminye imisebenzi emininingwaneni yamanani.
Amafomula adalwe afakwe njengesampula kokusetshenziswa komsebenzi ka-DATE. Ifomula ku:
- umugqa 5 ungena ngosuku lokuqala lwenyanga yamanje;
- umugqa 6 uguqula isicucu sombhalo (iselula A5) kuze kube usuku;
- umugqa 7 ubonisa usuku lwesonto usuku lokunikeza;
- umugqa 8 ubala izinsuku phakathi kwezinsuku zamanje nezangaphambilini;
- umugqa 9 uguqula inombolo ye-Julian Day (iseli A9) kuze kube yimanje;
- umugqa 10 uguqula usuku lwamanje (iseli A10) kuNombolo Yosuku LwaJulian.
Ulwazi olungezansi luhlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-DATE osefayeleni B4. Ukukhishwa komsebenzi kulokhu kubonisa usuku oluhlanganisiwe olwenziwe ngokuhlanganisa izakhi zomuntu ngamunye ezifakwe kumaseli A2 kuya ku-C2.
Ukufaka umsebenzi ka-DATE
Izinketho zokungena emsebenzini kanye neziphakamiso zalo kuphepha lokusebenzela zifaka:
1) Ukuthayipha ngesandla emsebenzini ophelele - khumbula nje ukuthi umyalelo kumele ube yiyyyy, mm, dd njenge:
= DATE (2016,01,16) noma,
= DATE (A2, B2, C2) uma usebenzisa izingqikithi zeseli
2) Ukusebenzisa ibhokisi eliphakamisa ngokuzenzakalelayo ukufaka umsebenzi kanye nezimpikiswano zalo
Amaspredishithi e-Google awasebenzisi amabhokisi wezingxoxo ukuze ufake izingqinamba zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.
Abahlukanisi bama-Comma
Uma usebenzisa noma iyiphi indlela yokufaka umsebenzi, phawula ukuthi amakhamera ( , ) asetshenziselwa ukuhlukanisa izimpendulo zomsebenzi ngaphakathi kubakaki abajikelezayo.
Izinyathelo ezingezansi zihlanganisa ukuthi ungangena kanjani umsebenzi we-DATE osesithombeni B4 esithombeni ngenhla usebenzisa ibhokisi eliphakamisa ngokuzenzakalelayo .
- Chofoza kuseli D4 ukuze wenze iseli elisebenzayo - yilapho imiphumela yomsebenzi we-DATE izoboniswa
- Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi - usuku
- Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala ngohlamvu D
- Uma i- DATE ibonakala ebhokisini, chofoza igama nge-pointer yegundane ukuze ufake igama lomsebenzi bese uvula ibakaki nxazonke e-cell D4
- Chofoza ku-cell A2 kushidi lokusebenzela ukuze ufake le nkomba yebheli njengengxabano yonyaka
- Ngemuva kokubhekisela kweseli, thayipha i-comma ( , ) ukuze wenze njengesahlukanisi phakathi kwezimpikiswano
- Chofoza kuseli B2 ukungena kule nkomba yebheli njengengxabano yenyanga
- Ngemuva kokubhekisela kweseli, thayipha enye i-comma
- Chofoza kuseli C2 ukungena kule nkomba yebheli njengengxabano yosuku
- Cindezela ukhiye wokungena kwikhibhodi ukungena ibhakha lokuvala " ) " nokuqedela umsebenzi
- Usuku kufanele luvele esitokisini B1 kufomethi ye-11/15/2015
- Uma uchofoza ku-cell B1 umsebenzi ophelele = DATE (A2, B2, C2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela
Qaphela : uma ukukhishwa kwiseli ye-B4 kungalungile ngemuva kokufaka umsebenzi, kungenzeka ukuthi iseli ifomathiwe ngendlela engalungile. Ngezansi kunezinyathelo ezibhalwe phansi zokushintsha ifomethi yosuku.
Ukushintsha Ifomethi Yosuku
Ukushintsha kufomethi yosuku kuma-Google Spreadsheets
- Qinisekisa amaseli eshidi lokusebenzela eliqukethe noma elizoqukatha izinsuku
- Chofoza kuFomathi> Inombolo> Usuku kumamenyu ukushintsha ukufometha kweseli kwifomethi yosuku esetshenziselwa izilungiselelo zesifunda yamanje - bheka ngezansi ukushintsha izilungiselelo zesifunda.
Ukushintsha izilungiselelo zesifunda
Njengezinhlelo zokusebenza eziningi ze-intanethi, i-Google Spreadsheets ayifani nefomethi yamanje yaseMelika - eyaziwa nangokuthi i- middle-endian - ye-MM / DD / YYYY.
Uma indawo yakho isebenzisa ifomethi yedethi ehlukile - njenge- big-endian (YYYY / MM / DD) noma i- little-endian (DD / MM / YYYY) ama-Google Spreadsheets angalungiswa ukuze abonise usuku ngendlela efanele ngokulungisa izilungiselelo zesifunda .
Ukushintsha izilungiselelo zesifunda:
- Chofoza ifayela ukuze uvule imenyu yefayela;
- Chofoza kuzilungiselelo ze-Spreadsheet ... ukuze uvule ibhokisi lengxoxo yezilungiselelo ;
- Ngaphansi Kwendawo ebhokisini lebhokisi, chofoza ebhokisini - inani elizenzakalelayo le- United States - ukubona uhlu lwezilungiselelo zezwe ezitholakalayo;
- Chofoza ezweni lakho lokuzikhethela ukwenza kube ukhetho lwamanje;
- Chofoza Londoloza izilungiselelo ngezansi kwebhokisi lebhokisi ukuze uvale futhi ubuyele ephepheni lokusebenzela;
- Amasha amasha afakwe efomini lokusebenzela kufanele alandele ifomethi yezwe elikhethiwe - izinsuku ezikhona zingadinga ukufomatha futhi ukuze ushintsho lusebenze.
Izinombolo zeNerial Negral nama-Excel Dates
Ngokuzenzakalelayo, i-Microsoft Excel ye-Windows isebenzisa uhlelo lokuqalisa oluqala ngonyaka ka-1900. Ukufaka inombolo ye-serial ye-0 ubuyisela usuku: Januwari 0, 1900. Ngaphezu kwalokho, umsebenzi we-Excel ka-DATE ngeke ubonise izinsuku ngaphambi kuka-1900.
Amapredishithi e-Google asebenzisa usuku loDisemba 30, 1899 ngenombolo ye-serial ye-zero, kodwa ngokungafani ne-Excel, ama-Google Amaspredishithi abonisa izinsuku ngaphambi kwalokhu ngokusebenzisa izinombolo ezimbi zenombolo ye-serial.
Isibonelo, usuku olungu-1 Januwari 1800 luba nenombolo ye-serial ye-Google + Spreadsheets futhi ivumela ukusetshenziswa kwalo emafomulini, njengokususa uJanuwari 1, 1850 - Januwari 1, 1800 okuletha inani le-18, 262 inombolo yezinsuku phakathi kwezinsuku ezimbili.
Uma usuku olufanayo lufakwe ku-Excel, ngakolunye uhlangothi, lolu hlelo luguqula ngokuzenzakalelayo usuku lokubhala idatha futhi lubuyisa i- #VALUE! inani lephutha uma usuku lisetshenziswe kwifomula.
Izinombolo ze-Julian Day
Izinombolo ze-Julian Day, njengoba zisetshenziswe izinombolo zezinhlaka zikahulumeni nezinye izinhlangano, yizinombolo ezimele unyaka nonyaka. Ubude balezi zinombolo buhluka kuye ngokuthi zingaki amadijithi asetshenziselwa ukumelela izingxenye zonyaka nezinsuku zenombolo.
Isibonelo, esithombeni ngenhla, inombolo ye-Julian Day esitokisini A9 - 2016007 - amadijithi ayisikhombisa ubude namadijithi amane okuqala wenombolo amele unyaka nonyaka wesithathu ngosuku. Njengoba kuboniswe esitokisini B9, le nombolo ibonisa usuku lwesikhombisa lonyaka ka 2016 noma ngoJanuwari 7, 2016.
Ngokufanayo, inombolo ka- 2010345 imele usuku lwama-345 lonyaka ka-2010 noma ngoDisemba 11, 2010.