Kudzivirira Zuva Zvikanganiso muMafomu achishandisa DATE Basa
Dates uye DATE Basa Rokuita
Google Spreadsheet DATE basa ichadzorera zuva kana nhamba yakatarwa yezuva nekubatanidza zuva rimwe nerimwe, mwedzi uye gore zvinhu zvakapinda semashoko ekushanda.
Somuenzaniso, kana DATE inotevera inoshanda yakapinda musero rekushanda,
= DATE (2016,01,16)
nhamba ye serial 42385 inodzorerwa, iyo inoreva musi waJanuary 16, 2016.
Kuchinja Serial Numbers kusvika Mazuva
Pazvakaiswa zvayo - sezvakaratidzwa muchitokisi D4 mumufananidzo wepamusoro, nhamba ye serial inowanzogadzirirwa kuratidza musi wacho. Matanho aidiwa kuita basa iri akanyorwa pasi apa kana zvichidiwa.
Kupinda Mazuva Mazuva
Kana ichibatanidzwa nedzimwe nhengo dzeGoogle Spreadsheet, DATE inogona kushandiswa kubudisa mavara akasiyana-siyana emazuva ekufananidzira sezvaratidzwa mumufananidzo uri pamusoro.
Imwe nzira inokosha yekushandiswa kwebasa - sezvinoratidzwa mumiganhu ye5 kusvika ku10 mumufananidzo uri pamusoro - ndeyekuita kuti mazuva acho apinde uye anotsanangurwa zvakarurama nezvimwe zvemashoko ezuva reGoogle Spreadsheet. Izvi zvinonyanya kuitika kana iyo inopinda deta yakaiswa senyaya.
DATE basa rinonyanya kushandiswa:
- kuti uratidze zuva rinobatanidza nhepfenyuro yezuva - yakadai segore, mwedzi, kana zuva kubva munzvimbo dzakasiyana-siyana mubasa rekushanda
- kuti ave nechokwadi chokuti mazuva akashandiswa mukuverenga anotsanangurwa sezuva (nhamba yedata) pane kunyora deta
DATE Basa & Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo.
Izwi rechirevo cheDATE basa nderekuti:
= DATE (gore, mwedzi, zuva)
gore - (rinodiwa) kupinda gore seine nhamba yechina yenhamba (yyyy) kana kuti sero rinoreva nzvimbo yaro mubasa
mwedzi - (inodikanwa) pinda mwedzi sehamba nhamba mbiri (mm) kana sero rinoreva nzvimbo yaro mune pepa rekushanda
zuva - (rinodiwa) kupinda zuva seiri nhamba mbiri nhamba (dd) kana sero rinoreva nzvimbo yaro mune pepa rekushanda
- #VALUE! kukanganisa kwekanako kunodzoserwa nebasa kana text text inopinda panzvimbo yenhamba-izvi zvinosanganisira kupinda muchitarisiko chekero rine mavara
- #NUM! kukanganisa kwekanako kunodzoserwa nebasa kana nhamba nhamba yechishanu - yakadai se-20016 - inopindirwa mumakaka egore
- kana chinhu chisina kubvumirwa pamwedzi kana masikati nharo, basa rinoshandura zvinogadzirisa zvakabuda kwebasa kune zuva rinotevera rakakodzera. Semuyenzaniso,
- = DATE (2016,13,1) - iyo ine 13 kumwedzi kukakavadzana - inogadzirisa gakava regore uye rinodzoka 1/1/2017
- = DATE (2016,01,32) - iyo ine mazuva makumi maviri nemaviri emwedzi waJanuary - inogadzirisa mwedzi wenyaya uye inodzorera 2/01/2016
- kana nhamba yepamusoro inopindirwa mukukakavadzana, kukosha kunotarirwa kune kukosha kwenhamba. Somuenzaniso, kukosha "10.25" kunogona kududzirwa se "10" nemabasa
DATE Basa Rakaitwa Muenzaniso
Mumufananidzo wepamusoro, DATE basa rinoshandiswa pamwe chete nemamwe mabasa akawanda mune mamwe maverengedzero ezuva.
Aya mazita akarongwa anongororwa semuenzaniso weDATE basa raanoshandisa. The formula in:
- mutsara 5 unopinda zuva rokutanga romwedzi uno;
- mutsara 6 unoshandura tambo yakanyanyisa (sero A5) kusvika pazuva;
- mutsara 7 unoratidzira zuva revhiki kwekupa zuva;
- mutsara 8 unoverengeka mazuva pakati pezuva rezvino uye rekare;
- mutsara 9 unoshandura aJulian Day Number (sero A9) kusvika zuva ranhasi;
- mutsara 10 unoshandura zuva razvino (sero A10) kuJulian Day Number.
Izwi iri pasi apa rinoshandisa matanho anoshandiswa kupinda muDATE basa iri muchitokisi B4. Kubudiswa kwebasa iri munyaya ino kunoratidza zuva rinoumbwa rakasikwa nekubatanidza rimwe zuva rezvinhu zviri mumasero A2 kusvika kuC2.
Kupinda DATE Basa
Zvisarudzo zvekupinda mubasa uye nharo dzayo mune pepa rekushandisa dzinosanganisira:
1) Kuita zvinyorwa mubasa rakakwana - ingoyeuka kuti urongwa hunofanira kuva yyyy, mm, dd akadai se:
= DATE (2016,01,16) kana,
= DATE (A2, B2, C2) kana kushandisa sero zvinyorwa
2) Kushandisa bhokisi - bhokisi rinopinza kupinda basa uye nharo dzaro
Google spreadsheets haishandisi dialog boxes kuti iite nharo dzebasa sezvazvinogona kuwanikwa mu Excel. Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.
Comma Separators
Paunoshandisa imwe nzira kuti upinde mubasa racho, ona kuti commas ( , ) inoshandiswa kuparadzanisa nharo dzebasa mukati mezvigaro zvepamusoro.
Matanho ari pasi apa anokwanisa kupinda maDATE basa riri muchitokisi B4 mumufananidzo pamusoro apa uchishandisa bhokisi rinotsanangura.
- Dzvanyira pane sero D4 kuti riite sero rinoshandiswa - iyi ndiyo iyo migumisiro yeDATE basa icharatidzwa
- Tora mufananidzo wakaenzana (=) uchitevedzwa nezita remabasa - zuva
- Sezvaunonyora, bhokisi -self- bhokisi rinowanikwa nemazita uye maonero ezvinyorwa zvinotanga netsamba D
- Apo DATE inowanikwa mubhokisi, chengetedza zita nezine mouse pointer kuti uise zita rebasa uye uzarure bhatikiti rose muchitokisi D4
- Dzvanya pachitokisi A2 mune pepa rekushanda kuti uise iyi seferensi seyero sekupikisa kwegore
- Mushure mokunge sero rinotarisa, shandisai comma ( , ) kuita separadzanisa pakati pemakakatanwa
- Dzvanya pachitokisi B2 kuti ugoona ino rekero seyikupikisa kwemwedzi
- Mushure mokunge sero rinotarisa, tora imwe kamera
- Dzvanyira pane cell C2 kuti ugoona iyi sero sekutaurirana sezuva rinopikisana
- Dhinda pikicha inopinda mubhobhoyo kuti uise bhizinesi rekuvhara " ) " uye kupedza basa
- Zuva racho rinofanira kuonekwa muchitokisi B1 mumutauro 11/15/2015
- Paunenge uchinyora pa cell B1 zvakakwana basa = DATE (A2, B2, C2) inowanikwa mubhairi yepamusoro pane pepa rekushanda
Cherechedza : kana zvakabuda muchitokisi B4 zvisina kururama mushure mekupinda mubasa, zvinogona kuti sero risina kuenzaniswa. Pasi apa pane nhanho dzakarongwa dzekushandura fomati yezuva.
Kuchinja Date Date Format
Kuti uchinje kune format yakatarwa muGoogle Spreadsheets
- Simbisai masero ari mubhuku rekushanda rine kana rine zvinyorwa
- Dzvanya paIndaneti> Nhamba> Dhizha riri mumam menus kuti uchinje mafomu ekufambisa kune fomu yezuva rinoshandiswa nemamiriro epanguva yemahara - ona pasi apa kuti uchinje zvirongwa zvemuganhu.
Kuchinja Mahara Mahara
Kufanana nemamwe mapurogiramu epaIndaneti, Google Spreadsheets yakashata kusvika kuAmerican format format - inozivikanwa sepakati-endian - ye MM / DD / YYYY.
Kana nzvimbo yako inoshandisa imwe yakarongeka yemazuva - yakadai se -big-endian (YYYY / MM / DD) kana zvishoma-endian (DD / MM / YYYY) Google Spreadsheets inogona kugadziriswa kuratidza musi wacho nenzira yakarurama nekugadzirisa zvirongwa zvemuganhu .
Kuti uchinje zvirongwa zvemuganhu:
- Dhinda Faira kuti uzarure Firimu menyu;
- Dzvanya pazvirongwa zveSpreadsheet ... kuti uzarure Bhokisi reZvibhokisi bhokisi;
- Pasi penzvimbo mubhokisi rebhokisi, sarudza bhokisi - kukosha kweUnited States - kuti uone urongwa hwezvigadziriro zvepanyika;
- Dzvanya kunyika yako yakasarudzwa kuti uite ikozvino kusarudzwa;
- Dzvanya Ponesa zvirongwa pasi pebhokisi rebhokisi kuti uvhare uye dzokera kubasa rekushanda;
- Mazuva matsva akapinda mune pepa rekufanirwa anofanirwa kutevera maitiro enyika yakasarudzwa - mazuva akange aine nguva angada kuiswazve zvakare kuitira kuti shanduko iite.
Negative Serial Numbers uye Excel Dates
Nenzira dzisiri, Microsoft Excel yeWindows inoshandisa purogiramu yezuva inotanga mugore ra1900. Kuisa nhamba ye serial ye 0 inodzorera musi: January 0, 1900. Mukuwedzera, Excel DATE basa harisi kuratidza mazuva asati asvika 1900.
Google Spreadsheets inoshandisa musi waDecember 30, 1899 nokuda kwenhamba yechirungu ye zero, asi kusiyana neExcel, Google Spreadsheets inoratidza mazuva asati aita izvi nekushandisa nhamba dzisina kunaka dze nhamba ye serial.
Somuenzaniso, musi waJanuary 1, 1800 unobata nhamba yechirwere ye -36522 muGoogle Spreadsheets uye inobvumira kushandiswa kwayo mumashonga, zvakadai sokubvisa kwaJanuary 1, 1850 -January 1, 1800 iyo inoguma nenhamba ye18, 262 - nhamba yemazuva pakati pemasikati maviri.
Apo zuva rimwe chete rakapinda muExcel, kune rimwe divi, purogiramu yacho inongotendeuka zuva racho kuisa deta uye rinodzorera #VALUE! kukanganisa kukosha kana zuva racho rinoshandiswa mumutsetse.
Julian Day Numeri
Julian Day Numeri, sezvakashandiswa nehuwandu hwemasangano ehurumende nemamwe masangano, nhamba dzinomiririra gore rakasiyana nemasikati. Kureba kwenhamba idzi kunowirirana zvichienderana nekuti ingani madijiti anoshandiswa kumirira gore uye zuva zvikamu zve nhamba.
Semuenzaniso, mumufananidzo uri pamusoro, Julian Day Number muchitokisi A9 - 2016007 - inomwe huwandu hwemazana neyekutanga nhamba dzedhamba dzinomiririra gore uye yekupedzisira vatatu pazuva regore. Sezvinoratidzwa muchitokisi B9, nhamba iyi inomiririra zuva rechinomwe regore ra2016 kana raJanuary 7, 2016.
Saizvozvowo, nhamba ya2013345 inomirira zuva rechi345 regore ra2012 kana musi waDecember 11, 2010.