Thuto: Tsela ea ho Sebelisa Mosebetsi oa NETWORKDAYS
Li-Sheets tsa Google li na le mesebetsi e mengata ea letsatsi e fumanehang, 'me mosebetsi ka mong sehlopheng o etsa mosebetsi o fapaneng.
Mosebetsi oa NETWORKDAYS o ka sebelisoa ho bala palo ea khoebo eohle kapa matsatsi a sebetsang pakeng tsa matsatsi a qalileng a ho qala le a ho qetela. Ka mosebetsi ona, matsatsi a mafelo-beke (Moqebelo le Sontaha) a tlosoa ka ho feletseng ho palo. Matsatsi a khethehileng, a kang matsatsi a phomolo a tloaelehileng, a ka tlosoa hape.
Sebelisa NETWORKDAYS ha u rera kapa u ngola litlhahiso ho fumana nako ea morero o tlang kapa ho khutlela morao-lekanya nako ea nako e phethiloeng.
01 ea 03
NETWORKDAYS Function Syntax le Arguments
Syntax ea mosebetsi e bua ka boemo ba mosebetsi mme o kenyelletsa lebitso la mosebetsi, li-brackets le likhang .
Sephetho sa mosebetsi oa NETWORKDAYS ke:
= NETWORKDAYS (qala_date, qetellong_date, matsatsi a phomolo)Likhopolo ke:
- qala_date - (e hlokehang) letsatsi la qala la nako e khethiloeng
- qetellong_date - (e hlokehang) letsatsi la ho qetela la nako e khethiloeng
Sebelisa litekanyetso tsa letsatsi, linomoro tsa serial , kapa li- cell reference bakeng sa sebaka sa data ena lefats'eng la likarabo tse peli.
- matsatsi a phomolo - (ka ho khetheha) matsatsi a mang kapa a mang a eketsehileng a khethiloeng matsatsing a ho sebetsa
Matsatsi a matsatsi a phomolo a ka ba matsatsing a letsatsi a kenngoa ka ho toba ka lebone kapa lisele tsa sele ho ea sebakeng seo data e sebetsang ho sona.
Lintlha: Kaha NETWORKDAYS ha e fetole liforomo ho fihlela joale, litekanyetso tsa letsatsi tse kenngoa ka kotloloho mosebetsing bakeng sa lintlha tsohle tse tharo li lokela ho kenngoa ho sebelisa DATE kapa mesebetsi ea DATEVALUE ho qoba liphoso tsa ho bala, joalokaha ho bontšoa moqolong oa 8 oa setšoantšo se tsamaeang le sehlooho sena .
#VALUE! palo ea phoso e khutlisetsoa haeba khang efe kapa efe e na le letsatsi le sa lokelang.
02 ea 03
Thuto: Bala Palo ea Matsatsi a Mosebetsi Pakeng tsa Matsatsi a Mabeli
Thuto ena e bontša kamoo mefuta e mengata ea mosebetsi oa NETWORKDAYS e sebelisetsoang ho bala palo ea matsatsi a mosebetsi pakeng tsa July 11, 2016 le la 4 November, 2016, ho Google Sheets.
Sebelisa setšoantšo se tsamaeang le sehlooho sena ho latela le thupelo ena.
Mohlala ona, matsatsi a mabeli a phomolo (la 5 le la 10 Phato) a etsahala nakong ena 'me a tlosoa ka kakaretso.
Setšoantšo se bonts'a hore na likarabo tsa mosebetsi li ka kenngoa ka ho toba ts'ebetsong joang e le litekanyetso tsa letsatsi kapa e le linomoro tsa serial kapa e le likarolo tsa sele ho ea sebakeng seo data e leng ho sona.
Mehato ea ho kenya Mosebetsi oa NETWORKDAYS
Li-Sheets tsa Google ha li sebelise lebokose la li- dialog box ho kenya likhopolo tsa mosebetsi joalokaha li ka fumanoa Excel. Ho e-na le hoo, e na le lebokose le bontšang likoloi tse hlahisang ha lebitso la mosebetsi le kenngoa ka seleng.
- Tobetsa seleng ea C5 ho e etsa hore e be sele e sebetsang .
- Tšoaea letšoao le lekanang ( = ) le lateloa ke lebitso la matsatsi a marang-rang a mosebetsi .
- Ha u ntse u thaepa, lebokose le nang le maikutlo a ikemetseng le hlaha ka mabitso le li-syntax tsa mesebetsi e qalang ka lengolo la N.
- Ha lebitso la matsatsi a marang-rang a hlaha lebokoseng, tobetsa lebitso ka mohope oa mouse ho kenya lebitso la mosebetsing le li-parenthesis tse bulehileng kapa li-bracket " ( " ka seleng ea C5.
- Tobetsa ho seleng ea A3 leqepheng la mosebetsi oa ho kenya mohalaleli oa sele ena e le qabang ea qala_date .
- Ka mor'a hore ho buuoe sele, khetha mofuta oa comma ho iketsa karohano pakeng tsa likhang.
- Tobetsa seleng ea A4 ho kenya reference ea sele ena e le phetoho ea ho qetela_date .
- Ka mor'a hore ho buuoe sele, khetha mofuta oa bobeli.
- Totobatsa lisele tsa A5 le A6 kahare ho leqephe hore u kenye boitsebiso bona ba lisele tse kang likhang tsa phomolo .
- Tobetsa konopo ea Kena ho lebokose ho kenya li-parenthesis tsa ho qetela " ) " le ho phetha mosebetsi.
Palo ea matsatsi a sebetsang-83-e hlaha ka seleng ea C5 ea mosebetsi oa mosebetsi.
Ha o tobetsa seleng ea C5, mosebetsi o feletseng
= NETWORKDAYS (A3, A4, A5: A6) e hlaha kahare ea foromo ka holim'a leqephe la mosebetsi.
03 ea 03
The Math Behind the Function
Kamoo Li-Sheets tsa Google li fihlang karabo ea 83 mohloling oa 5 ke:
- Kakaretso ea matsatsi a beke pakeng tsa la 11 Phupu le la 4 November, 2016, e lekana le 85 (libeke tse 17 x 5 ka beke). Ke phello bakeng sa mela ea 3 le ea 4 moo phehisano ea phomolo e sa lumelloe.
- Ho tloha ka kakaretso, matsatsi a mabeli a matsatsi a phomolo a hlalositsoeng (la 5 le la 10 Phutheho) a tlosoa ho tsoa ka lebaka la matsatsi a 83 a sebetsang.
Tlhokomeliso: Haeba matsatsi a mafelo-beke a mang ho feta Moqebelo le Sontaha kapa letsatsi le leng ka beke, sebelisa mosebetsi oa NETWORKDAYS.INTL.