Dzidzo: Ungashandisa sei NETWORKDAYS Function
MaSpredishiti eGoogle ane mabasa akawanda ezuva anowanika, uye rimwe nerimwe riri muboka rinoita basa rakasiyana.
Basa reNETWORKDAYS rinogona kushandiswa kuverenga nhamba yebhizinesi rose kana mazuva ekushanda pakati pekutanga mazuva ekutanga uye ekupedzisira. Nebasa iri, mazuva ekupera kwevhiki (Mugovera neSvondo) anobva abviswa zvachose kubva pachiyero. Mazuva chaiwo, akadai sezororo rezvemitemo, anogonawo kubviswa.
Shandisa NETWORKDAYS paunenge uchigadzirira kana kunyora zvirongwa kuti uone nguva yechirongwa chinotevera kana kuti kudzokera shure-kuverenga nguva yakashandiswa pakupedzisa.
01 of 03
NETWORKDAYS Basa reSintax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara weNETWORKDAYS basa nderekuti:
= NETWORKDAYS (start_date, end_date, holidays)Nharo dzinoti:
- start_date - (inoda) zuva rokutanga remakore akasarudzwa
- end_date - (inoda) zuva rokupedzisira remwaka wakasarudzwa
Shandisa zuva maitiro, serial nhamba , kana sero rinotarisa kune nzvimbo yedata iyi mune pepa rekushandira kwemashure maviri aya.
- mazororo - (optional) rimwe kana kuti mamwe mazuva anowanikwa asina kubviswa mazuva ose ekushanda
Mazuva ezororo anogona kunge ari maitiro anoiswa zvakananga mumutsetse kana sero zvinyorwa kune nzvimbo yedhesi mubasa rekushanda.
Nhamba: NETWORKDAYS haina kuchinja maitiro ekuti zvive zvamazuva ano zvigadziriswe, maitiro ezuva akaiswa zvakananga mubasa kwemashure matatu ose anofanira kuiswa achishandisa DATE kana DATEVALUE mabasa kuitira kuti arege kuverenga zvikanganiso, sezvakaratidzwa mumutsara 8 wemufananidzo unofambidzana neizvi .
The #VALUE! kukanganisa kwekanako kunodzoserwa kana chero kukakavara kuchiine zuva risingabhadhari.
02 of 03
Tutori: Verenga Nhamba Yemazuva Okushanda Pakati Pemazuva maviri
Iyi dzidzo inoratidzira kushandiswa kwakasiyana-siyana kweNETWORKDAYS basa rinoshandiswa kuverenga nhamba yezuva rebasa pakati paJuly 11, 2016, uye November 4, 2016, muGoogle Sheets.
Shandisa mufananidzo unoenda munyaya ino kuti uite pamwe neyikudzidzisa.
Muchiitiko chacho, mazororo maviri (September 5 neOctober 10) anoitika munguva ino uye anodzingwa kubva pachikamu.
Mufananidzo wacho unoratidza kuti nharo dzebasa racho dzinogona sei kupinda mukati mebasa sezuva rinokosha kana se nhamba dzemajeri kana sero rinotaurwa kune nzvimbo yedhidhi mune pepa rekushanda.
Matanho ekupinda muNETWORKDAYS Basa
MaSpredishiti eGoogle haashandisi dialog boxes kuti apinde nharo dzebasa sezvazvinogona kuwanikwa muExcel. Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.
- Dzvanya pachitokisi C5 kuti uite sero rinoshanda .
- Tora mufananidzo wakaenzana ( = ) uchitevedzwa nezita rebasa remasikati .
- Sezvaunonyora, bhokisi -self- bhokisi rinowanikwa nemazita uye syntax yemabasa anotanga netsamba N.
- Apo zita rekubudiswa kwemasikati rinowanikwa mubhokisi, tanga pazita nezita mouse pointer kuti uise zita rebasa uye vabereki vakashama kana bhodhi rakapoteredza " ( " muchikamu cheC5.
- Dzvanya pane sero A3 mune pepa rekushanda kuti uite ino seferensi seyokutanga-date argument.
- Mushure mokutaura kwesero, nyora komma kuti uite separadzanisa pakati pemakakatanwa.
- Dzvanya pane sero A4 kuti upinde muchitsauko chesekese segumo_date argument.
- Mushure mokunge sero rinotarisa, tora kamera yechipiri.
- Svinura masero A5 neA6 mubasa rekushandisa kuti uise huwandu hwemaferensi esero seheti yeholide .
- Dhinda pikicha inopinda mubhokisi kuti uwedzere mazera ekuvhara " ) " uye kupedza basa.
Nhamba yemazuva ekushanda-83-inowanikwa muchitokisi C5 chebasa rekushanda.
Paunenge uchinyora pane seC5, basa rakakwana
= NETWORKDAYS (A3, A4, A5: A6) inowanikwa mubhairi yepamusoro pane pepa rekushanda.
03 of 03
The Math Behind the Function
Mabhizimusi eGoogle anosvika sei mhinduro ye 83 mumutsara we5 ndeye:
- Nhamba yose yevhiki vhiki pakati paJuly 11 neNovember 4, 2016, yakaenzana ne 85 (masvondo 17 x 5 mazuva pavhiki). Ndiyo mhedziso yemiganhu ye3 ne4 apo mhirizhonga yezororo haibvumirwi.
- Kubva pane izvi zvose, mazuva maviri ezororo akarondedzerwa (September 5 naOctober 10) vanobviswa kuti vabve pamagumisiro emazuva makumi matanhatu ekushanda.
Cherechedza: Kana mavhiki ekupedzisira ari mamwe kunze kweMugovera neSvondo kana zuva rimwechete pavhiki, shandisa basa reNETWORKDAYS.INTL.